Sharon Smith
Sharon Smith
  • 204
  • 8 773 049
How to Automate Weekly Timesheet Template in Excel for Payroll
How to automate a weekly employee timesheet in Excel using formulas to auto-populate the dates in the pay period, how to calculate time in and out including breaks, as well as how to accurately calculate overtime for hours worked over 40 in the work week. We will also create a macro to automatically create 52 weekly timesheets in a Workbook. This template will automatically update the pay period end date, and all days and dates in the pay period based on entering/updating the pay period start date. Also, simply enter base pay rate and all other totals will auto-calculate.
Check out my other videos on timesheets:
czcams.com/video/YTtpcf4vg1A/video.html - Create a Timesheet Template from Scratch
czcams.com/video/HDyyZzC_CPU/video.html - Automate a Bi-Weekly Timesheet
czcams.com/video/dSOKqNcq2I8/video.html - Automate a Semi-Monthly Timesheet
Link to purchase the fully automated templates if you are interested in getting a jump start: www.etsy.com/listing/1745072850/employee-timesheet-template-for-payroll
TIMESTAMPS ⏰
00:00 Automate Weekly Timesheet in Excel
00:29 Auto-populate Dates in Excel
02:05 Format Time Calculations in Excel
03:44 Calculate Overtime in Excel
05:26 Auto Create Weekly Timesheets with Macros
VBA Code Used in this Video:
Sub CreateWeeklyTimesheets()
Dim ws As Worksheet
Dim i As Integer
Dim newSheet As Worksheet
Dim startDate As Date
' Set the starting date in Week 1's G3 cell
Set ws = ThisWorkbook.Sheets("Week 1")
startDate = ws.Range("G3").Value
' Loop to create Week 2 through Week 52
For i = 2 To 52
' Copy the Week 1 sheet
ws.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
' Rename the new sheet
Set newSheet = ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
newSheet.Name = "Week " & i
' Update the start date in G3
newSheet.Range("G3").Value = startDate + (i - 1) * 7
Next i
MsgBox "52 weekly timesheets created successfully!"
End Sub
COURSE 🎒
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: czcams.com/play/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs.html
CHANNEL LINK đŸ“ș
www.youtube.com/@SharonSmith
Visit my Channel page on CZcams to see all my videos, playlists, community posts and more!
TEMPLATES 📄
Check out my helpful list of templates available for purchase: creatoriq.cc/43c51cv
Thank you for supporting my channel! 🌟
FREE DOWNLOADS âŹ‡ïž
✩ Visit mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
CONNECT WITH ME 📎
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: www.linkedin.com/in/sharonsmithhr
Twitter: SharonSmithHR
Instagram: sharonsmithlearning
Facebook: SharonSmithLearning
GEAR ⚙
🎙 Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
đŸ–± Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
đŸŽ„ Screen Recording Software: techsmith.z6rjha.net/NZG5b
📗 Green Screen: amzn.to/2DnHsY2
📾 Camera: amzn.to/39KvpQA
🔌 Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES 📚
✏ JotForm: www.jotform.com/pricing/?
đŸ–„ïž TechSmith Camtasia Screen Recording: techsmith.z6rjha.net/SharonSmithHR
Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
SUPPORT THIS CHANNEL 🙌
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url
If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❀
PLAYLISTS đŸŽ„
➀ Jotform Tutorials: czcams.com/play/PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD.html
➀Creating Fillable Forms: czcams.com/video/YktZ3B-tyqs/video.html
➀PowerPoint Tutorials: czcams.com/play/PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM.html
➀ Excel Tutorials: czcams.com/play/PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90.html
➀ Excel Tips & Tricks: czcams.com/play/PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW.html
➀ Word Tutorials: czcams.com/play/PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45.html
zhlédnutí: 318

Video

How to Automate Semi-Monthly Employee Timesheet Template in Excel for Payroll
zhlĂ©dnutĂ­ 378Pƙed 14 dny
How to automate a semi-monthly employee timesheet in Excel using formulas to auto-populate the dates in the pay period, and use special conditional formatting tricks to hide or display all the dates in your pay period range on the timesheet. We'll set up a drop-down list for PTO type selection, and then see how to set it up for calculating hours, overtime, and total pay. This template will auto...
How to Automate Bi-Weekly Timesheet Template in Excel for Payroll
zhlĂ©dnutĂ­ 1,2KPƙed 21 dnem
How to automate a bi-weekly timesheet in Excel using special formulas to auto-populate the dates in the pay period, we'll set up a drop-down list for PTO type selection, and then see how to set it up for calculating hours, overtime, and total pay. This template will automatically update the pay period end date, and all days and dates in the pay period based on entering/updating the pay period s...
How to Create Employee Timesheet Template in Excel for Payroll - Design a Bi-Weekly Timesheet
zhlĂ©dnutĂ­ 1,2KPƙed měsĂ­cem
How to create an employee timesheet template in Excel for Payroll from scratch. We’ll design a template for inputting daily hours for a bi-weekly pay period. This bi-weekly timesheet template can be printed or filled in electronically. You'll see how to format the spreadsheet, draw lines and tables, insert proper column headers and create signature lines. We'll create custom margins to ensure t...
Footnotes in Word - Insert, Customize, Convert & Delete Footnotes and Endnotes - Step-By-Step
zhlĂ©dnutĂ­ 491Pƙed měsĂ­cem
How to create Footnotes and Endnotes in Microsoft Word. You'll learn how to insert, customize, convert, and delete Footnotes & Endnotes. Adding Footnotes and Endnotes to your word documents is easy and you can modify how the superscripts appear, as well as delete them and ensure proper auto-renumbering occurs. Footnotes and Endnotes are useful for adding references, explanations, or comments to...
How to Auto Format Chapters in Word - Record a Macro & Make Chapter Headings go to Center of Page
zhlĂ©dnutĂ­ 533Pƙed 2 měsĂ­ci
How to auto format Chapters in Word so they appear centered on single pages in your document. We'll do this by creating a Macro with a shortcut button on your Quick Access Toolbar. This helps you automate a task in Word that would normally be repetitive and time consuming if you did it manually. Save time by assigning your Macro to an icon button on the Ribbon or Quick Access Toolbar. We'll als...
How to Create a Progress Circle Chart in Excel - Dynamically Display Percentage of Completion
zhlĂ©dnutĂ­ 966Pƙed 2 měsĂ­ci
How to create a progress circle chart in Excel to use as a progress tracker and dynamically display percentage of completion towards a goal. This will be a doughnut chart that will show the percentage of a budget spent and will display in the middle of the circle and will dynamically update as your data is entered. We'll also format the chart to make it stand out. Then you'll see how to use con...
Create a Reset Button in PDF Fillable Forms in Adobe Acrobat Pro - Reset Form Fields in PDF
zhlĂ©dnutĂ­ 2,1KPƙed 3 měsĂ­ci
How to create a reset form button in your PDF fillable form with Adobe Acrobat Pro. Add a button to your PDF form that users can click to clear all the form field data so they can quickly and easily reuse the form. This button is easy to program and format and is a helpful tool for forms that need to be reused often. TIMESTAMPS ⏰ 00:00 Create Reset a Form Button in PDF 00:14 Prepare a PDF Form ...
Create a Reset Form Button in Word - How to Reset Form Fields in Word Fillable Forms
zhlĂ©dnutĂ­ 2,4KPƙed 3 měsĂ­ci
How to reset form fields in a Word fillable form by adding an ActiveX command button that when a user clicks it, all of the form fields will be cleared out. Create a reset form button in Word that will work to clear both Legacy form fields and Content Control form fields. We will insert a command button on our form and then program the button with the VBA code below. This button will uncheck a ...
How to Create a Fillable Form in Word for Mac
zhlĂ©dnutĂ­ 6KPƙed 4 měsĂ­ci
Learn how to create a fillable form in Word for Mac that has form fields including text boxes, drop-down lists, and checkboxes. See how to configure options in your form fields like setting a maximum character limit and forcing date formatting. In this video, we will build and format this form template from scratch with tables and section headers. But in case you already have your form template...
Add Shortcuts to Ribbon in Excel - Speed Up your Excel Workflow using the Quick Access Toolbar
zhlĂ©dnutĂ­ 881Pƙed 5 měsĂ­ci
Speed up your Excel workflow by adding shortcuts to the Ribbon in Excel. Personalize the Quick Access Toolbar and arrange icons for the commands you use most frequently. Get to your favorite commands and shortcuts in fewer clicks by adding them to a custom group on any tab in Excel. In this example, we create a custom group on the Home tab next to the font area on the Ribbon where we place the ...
How to Create Sheet Tabs from a List - Then Make a Table of Contents with Links
zhlĂ©dnutĂ­ 1,8KPƙed 5 měsĂ­ci
How to automatically generate multiple sheet tabs in your Excel workbook based on an existing list of values. Create sheet tabs from your list then make a table of contents tab with hyperlinks to all the other tabs. Generate your tabs automatically without having to manually type them out and without VBA. Use this Pivot Table trick to save time and auto create multiple sheet tabs from your list...
Set a Maximum Character Length in Word Fillable Form - Set Max Character Limit
zhlĂ©dnutĂ­ 6KPƙed 6 měsĂ­ci
How to set a maximum character length on a text form field in Microsoft Word. Specify the character limit for a text form field in Word and stop form cells from expanding. This is something you can set up if you need to limit how much a user types into a form field and prevent the field from expanding your document formatting. By default, form fields accommodate an unlimited number of character...
How to Create a Fillable Form in Google Docs
zhlĂ©dnutĂ­ 26KPƙed 6 měsĂ­ci
Learn how to create fillable forms in Google Docs including form elements like text fields, dropdown list selections, and checkboxes. In this step-by-step tutorial we will create a fillable form in Google Docs from scratch. See how to insert and place a logo on your form, then how to use tables and borders to create fillable text boxes on your Google Doc. You'll see how to insert and set up dro...
Create Date Countdown in Excel - Countdown Timer of Days Remaining
zhlĂ©dnutĂ­ 14KPƙed 6 měsĂ­ci
How to create a Date Countdown in Excel to show you both the number of calendar days remaining until an event date, as well as how to calculate the number of working days left between now and that particular date. If you need to count "days left" or "days to go" to a particular date, you can achieve this in a way that will automatically update whenever you open the workbook by using the TODAY()...
Auto Populate Form Fields in Adobe PDFs - Repeating a Field in Other Parts of Your PDF
zhlĂ©dnutĂ­ 11KPƙed 6 měsĂ­ci
Auto Populate Form Fields in Adobe PDFs - Repeating a Field in Other Parts of Your PDF
How to Create a Table of Contents with Hyperlinks in Excel
zhlĂ©dnutĂ­ 11KPƙed 6 měsĂ­ci
How to Create a Table of Contents with Hyperlinks in Excel
Export PDF Form Field Data from Adobe Acrobat Pro to Excel - Adobe Acrobat Forms Data Collection
zhlĂ©dnutĂ­ 11KPƙed 6 měsĂ­ci
Export PDF Form Field Data from Adobe Acrobat Pro to Excel - Adobe Acrobat Forms Data Collection
Make Text See-Through in PowerPoint - Cool Text Transparency Technique
zhlĂ©dnutĂ­ 10KPƙed 8 měsĂ­ci
Make Text See-Through in PowerPoint - Cool Text Transparency Technique
How to Analyze Data Quickly in Excel - Using Excel's Built-in AI Features
zhlĂ©dnutĂ­ 1,5KPƙed 8 měsĂ­ci
How to Analyze Data Quickly in Excel - Using Excel's Built-in AI Features
How to Insert a Dynamic Pivot Chart in PowerPoint - Excel to PowerPoint Integration
zhlĂ©dnutĂ­ 4,8KPƙed 9 měsĂ­ci
How to Insert a Dynamic Pivot Chart in PowerPoint - Excel to PowerPoint Integration
Simplifying Pivot Tables with Timelines and Slicers - Data Visualization Made Easy
zhlĂ©dnutĂ­ 1KPƙed 9 měsĂ­ci
Simplifying Pivot Tables with Timelines and Slicers - Data Visualization Made Easy
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
zhlĂ©dnutĂ­ 3,8KPƙed 9 měsĂ­ci
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
How to Create Pivot Tables in Excel to Analyze Data - Pivot Tables Made Easy for Beginners
zhlĂ©dnutĂ­ 3KPƙed 9 měsĂ­ci
How to Create Pivot Tables in Excel to Analyze Data - Pivot Tables Made Easy for Beginners
How to Hide Confidential Data in Excel - Hiding Social Security Numbers & Credit Card Numbers
zhlĂ©dnutĂ­ 4KPƙed 9 měsĂ­ci
How to Hide Confidential Data in Excel - Hiding Social Security Numbers & Credit Card Numbers
Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time
zhlĂ©dnutĂ­ 3,4KPƙed 9 měsĂ­ci
Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time
How to Reset Calculated Field to Zero in Adobe Acrobat Pro PDF Form
zhlĂ©dnutĂ­ 1,7KPƙed 10 měsĂ­ci
How to Reset Calculated Field to Zero in Adobe Acrobat Pro PDF Form
How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
zhlĂ©dnutĂ­ 13KPƙed 10 měsĂ­ci
How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
Create Engaging PowerPoint Presentations With Free Visual Tools
zhlĂ©dnutĂ­ 1KPƙed 10 měsĂ­ci
Create Engaging PowerPoint Presentations With Free Visual Tools
How to Add a Photo to Header or Footer and Make it a Circle in Microsoft Word
zhlĂ©dnutĂ­ 4,2KPƙed 10 měsĂ­ci
How to Add a Photo to Header or Footer and Make it a Circle in Microsoft Word

Komentáƙe

  • @paulae1544
    @paulae1544 Pƙed 2 hodinami

    I hid my sheet. Now I cant see to get it back. I am not given the options for the sheet nor any other sheets in the workbook when I go back in. Those left side windows are gone. H.E.L.P😅

  • @bl63
    @bl63 Pƙed 13 hodinami

    How do you add a drop down list reset?

  • @shelenejackson7834
    @shelenejackson7834 Pƙed 16 hodinami

    Wow, that was such a great help. Thank you!!

  • @BeverlyBrickerMD
    @BeverlyBrickerMD Pƙed 16 hodinami

    There's a difference between "electronic" signature and "digital" signature. The latter is a certificate that goes through a validation process. I guess this video is out of date.

  • @rajasekaranalagar2587
    @rajasekaranalagar2587 Pƙed 19 hodinami

    While typing in some form field, first letter is coming in small font as i desire and second letter onwards font size gets changing bigger automatically. How to correct it

  • @rafaelxavier8161
    @rafaelxavier8161 Pƙed 21 hodinou

    I miss the part that you teach how to create a submit button

    • @SharonSmith
      @SharonSmith Pƙed 21 hodinou

      Hello! Here is my video on how to insert a Submit button on PDF forms: czcams.com/video/1iczBlPYREE/video.html. Hope this helps! Thanks for watching!

  • @TCMcDonald0915
    @TCMcDonald0915 Pƙed dnem

    Your videos are always so helpful. On different topic related to word. Is there such a code that will compare 2 bookmarks based on text entered by user and if there is text (any text not specific text) in one it enters the text from that bookmark but if there is no text in that bookmark then it enters the text entered in the other bookmark?

  • @perrym451
    @perrym451 Pƙed dnem

    How to you get it to return 'Yes' or 'No' rather than True or False?

  • @MAMASDEALS
    @MAMASDEALS Pƙed 2 dny

    Thank you for this, it is amazing. Do you by chance have a video that goes off/hand in hand with this inventory sheet to track costs for the year?

  • @GuruprasadNH
    @GuruprasadNH Pƙed 2 dny

    Good, thanks for video tutorials.

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Glad to help! Thanks for watching!

  • @lindasmith945
    @lindasmith945 Pƙed 2 dny

    Sharon, you are always equipped with the most helpful information and knowledge! Your presentation is excellent! Thank you so much!!

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Thank you so much, Linda! I’m so glad you find my videos helpful! Thanks for taking time to leave a nice comment!

  • @lucianoriquet8552
    @lucianoriquet8552 Pƙed 2 dny

    Quite nice explanation

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Thank you for watching! Glad you found it helpful!

  • @syedikramullah1114
    @syedikramullah1114 Pƙed 2 dny

    Please make a series on Power BI with details.

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Thanks for the suggestions! Take care!

  • @syedikramullah1114
    @syedikramullah1114 Pƙed 2 dny

    Superb Sharon nice to see you again after the break. Love ❀ u mam

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Thank you!! Hope you are doing well! Thanks for watching!

  • @Designsbycozy
    @Designsbycozy Pƙed 3 dny

    Glad I came across your channel, you make it so easy to follow along.

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      I'm so glad to hear that! Thanks for watching my videos!

  • @BlackRussian0795
    @BlackRussian0795 Pƙed 3 dny

    Wow!!! thank you so much!!! So clear, concise, and easy to understand.

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      I'm so glad to hear that! Thanks for watching my videos!

  • @keerthananratnajothy4094

    Started watching your videos recently. They are quite helpful. Thanks and lots of love from Sri Lanka!

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Hello and thank you so much for watching my videos and for subscribing to my Channel! I'm so glad you found me and that you find my videos helpful. Take care!

  • @khodorfattah6052
    @khodorfattah6052 Pƙed 4 dny

    thank you sooo much !!

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Glad you found it helpful! Thanks for watching!

  • @farzanakarim5294
    @farzanakarim5294 Pƙed 4 dny

    Thanks a lot for explaining it easily. Helped with my proposal writing..

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      That is awesome! Good luck with your proposals! Thanks for watching!

  • @azn8282
    @azn8282 Pƙed 4 dny

    Thank you for creating a great videos I wish I have seen your video before I worked on pdf forms I struggled so much but got the hang of it but this definitely helps save time and to understand more clearly and how to use the options in adobe acrobat. Thank you for sharing your knowledge and making it easier to learn!

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      I'm so glad you have found my Adobe Acrobat videos helpful! Glad to help and thanks so much for watching my videos!

  • @erniesulovic4734
    @erniesulovic4734 Pƙed 4 dny

    My formula keeps changing cells down by one for sheet 2 so I'm not getting the correct answers. Nothing of any videos I've watched is helping....frustrating the crap outta me and supposed to be so easy to do

  • @abigailrebello81
    @abigailrebello81 Pƙed 6 dny

    Thank you!

  • @antonybeltran4053
    @antonybeltran4053 Pƙed 6 dny

    loving the way you teach, im dyslexic and a beginner, so the voice over is so helpful, thanks sharon

    • @SharonSmith
      @SharonSmith Pƙed 2 dny

      Thanks so much! I'm so glad you find my videos helpful! I'm glad you are learning from my videos. My best to you! Take care!

  • @ImranMalik-dg8xm
    @ImranMalik-dg8xm Pƙed 6 dny

    Thumbs up

  • @user-oj2qi7ix2f
    @user-oj2qi7ix2f Pƙed 7 dny

    Hi Sharon, thanks again for your helpful videos! I have a problem: I created a fillable form in word with Content Control form fields. I need to insert an image content control in the header and footer of the page to allow the customer to insert their letterhead but I can't. I believe that Word does not allow the insertion of form fields in the header and footer of the page. Is it correct? How can I solve it?

  • @user-oj2qi7ix2f
    @user-oj2qi7ix2f Pƙed 7 dny

    Thank you very much Sharon! Your videos are tremendously useful. Only one question: which are the criteria to use Legacy Tools or Content Control form fields?

  • @user-ep1un1pq1e
    @user-ep1un1pq1e Pƙed 7 dny

    Can you help me please? I have a protected Word form that I am using that contains picture boxes, Once emailed many of my colleagues are unable to upload a picture, the image with the picture and monitor in front is not visible. Any suggestions? Kind regards.

  • @piyaomietimi7992
    @piyaomietimi7992 Pƙed 7 dny

    This is so helpful. Please how can I get the sample excel sheet so I can practice?

  • @WoodieFL
    @WoodieFL Pƙed 7 dny

    I loved your video and presentation and found a few things I needed to change. However, my calculated field is still not working. I've tried everything I can think of but no luck. Any other ideas?

  • @johnlalley5824
    @johnlalley5824 Pƙed 7 dny

    What if I don't have an option for "Format" under the Text Field Properties?

  • @dfacko
    @dfacko Pƙed 8 dny

    Dear Sharon I have reviewed most of your tutorials, which are excellent, and I have learned a lot and successfully applied it. However, I haven’t found (or maybe I didn’t recognize) what I currently need: I have to create a PDF form for a report from a site visit where some installation works will take place. So, our employee arrives at the address with a tablet (the tablet is online, equipped with a camera and stylus), Before he starts site visit, he will download, using the tablet, a pre-prepared form for each location he visits, which already includes basic information about the location, client name, address, contract number, etc. At the site, he only needs to fill in a few additional fields in the usual text boxes, but I I can’t reach a solution for a few more fields: 1. The layout of the location is a pre-inserted image in the form. Our employee needs to mark several points on this image with the stylus, draw a few lines, and enter some numbers, so that this remains recorded on a layer above the image. 2. There should be an option to insert a photos taken on-site at several designated positions: the idea is that he clicks in the form to initiate the tablet’s camera and immediately inserts the taken photo into the document. Alternatively, he should be able to insert a photo from the tablet’s gallery. After that, he should also be able to draw several lines and enter a few numbers over the inserted photo (as in point 1). 3. At the end of the report, there should be a field for the client’s signature. When our employee finishes the site visit, he presents the report to the client and offers him/her to sign on the tablet’s display with a finger or stylus. So, NOT a digital signature or certificate, but a handwritten signature. I would appreciate it if you could give me advice on how to create fields for these 3 points. Or even better, if you could create a PDF form with these 3 elements (design and field positions are irrelevant) and send it to me. Thank you in advance.

  • @taffy6886
    @taffy6886 Pƙed 8 dny

    This is amazing. I have used it for my inventory and am now using it to help me format some other docs. Thank You soooo much.

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      That is awesome! I’m so glad to hear this template has helped you! Thanks so much for watching my videos and taking time to leave a nice comment!

  • @jordynnkelly6659
    @jordynnkelly6659 Pƙed 8 dny

    Hi. really helpful video. thankyou. yt doesn't have the save option for this though. ?

  • @mrsouzzo
    @mrsouzzo Pƙed 8 dny

    OMG... thank you so much... I have spent hours looking for this solution and I finally found it!!!

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      I’m so glad you found my videos and that they helped you out! Thanks for watching!

  • @user-fy4yd9tz4w
    @user-fy4yd9tz4w Pƙed 9 dny

    Not sure if you monitor this video for comments but I can’t find any instructional videos for comparing two columns to find a matching name IN A TEXT STRING. Ie one cell may be Mr. John smith in one column and John Smith , Mr. in the second column. I want to be able to match the name Smith. Thank you. I do find your explanation easy to understand so I’m hoping you have a simple solution

  • @stopnprintcafe6745
    @stopnprintcafe6745 Pƙed 10 dny

    This is one of the best excel inventory videos I've come across. I am subscribing to form part of your inventory of subscribers..lol. I love the video please keep making more

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      😄 Thank you so much for subscribing to my Channel and for watching my videos! I’m so glad you found this video and template helpful! Best of luck to you!

  • @annoyingwizard
    @annoyingwizard Pƙed 10 dny

    While selecting the options from the dropdown list, I accidently selected one entry which shouldn't be there. But now, I'm unable to delete it without removing all the other selections with it. What to do in such a case?

  • @hectorsalamanca8117
    @hectorsalamanca8117 Pƙed 10 dny

    Thank You for this!

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      Glad you found it helpful! Thanks for watching!

  • @ebrahimsalah7101
    @ebrahimsalah7101 Pƙed 11 dny

    I wish you the best You are a life saver thanks a lot Sharon

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      Thank you so much for watching my videos! Glad you find them helpful!

  • @ymc_ceo
    @ymc_ceo Pƙed 11 dny

    Superwoman!!!!!

  • @FullStack-d4e
    @FullStack-d4e Pƙed 11 dny

    Your presentation and communication skills are tope tier! Thank you for the time investment and for sharing.

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      Thank you so much for leaving such a nice comment! I’m glad you found my videos helpful!

  • @js4513
    @js4513 Pƙed 12 dny

    Your videos are so well done. Very detailed but very easy to follow along to. Thank you so much!

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      I’m so glad you find my videos helpful! Thanks for the nice comment and for watching my videos!

  • @lazarusWafula-bd2rs
    @lazarusWafula-bd2rs Pƙed 13 dny

    Sharon I have many quiz to ask u

    • @SharonSmith
      @SharonSmith Pƙed 8 dny

      Thanks for watching! Let me know if you have any questions.

  • @lindasmith945
    @lindasmith945 Pƙed 13 dny

    Great information and video! Thank you Sharon!

    • @SharonSmith
      @SharonSmith Pƙed 13 dny

      Glad you found it helpful!! Thanks so much for watching!

  • @daviddanielson3402
    @daviddanielson3402 Pƙed 13 dny

    Hi Sharon Smith I need your help! Is it to possible Populate one field with the data from three different fields. So that data can be copied and pasted as a group of data for use in a File Name. This comes from the use of a Service Report in order to be consistent in File Names.

  • @valentinadelafuente9538
    @valentinadelafuente9538 Pƙed 13 dny

    This is a great video! One question: Is there any way to auto populate form fields without restricting editing? I am working on a Microsoft Word Document that that is more "essay like", rather than a typical fillable form. In other words, it's continuous text with paragraphs, etc. The document has multiple fields where I want to insert "name", or ther such fields, but I don't want to restrict editing of the rest of the document. Can this be done?

  • @SharonSmith
    @SharonSmith Pƙed 13 dny

    Here is the conditional formatting formula used in this video that references the specific cells in this semi-monthly timesheet template: =OR(AND(DAY($C$10)=1, DAY($C10)>15), AND(DAY($C$10)=16, MONTH($C10)<>MONTH($C$10))) Save time and purchase these templates and you'll get the Semi-Monthly, Bi-Weekly and Weekly timesheet templates with all the formulas and formatting for $10. This helps support my channel so I can continue to make more videos for you all. Thanks so much for watching! Here is the link to my Etsy listing: www.etsy.com/listing/1745072850/employee-timesheet-template-for-payroll

  • @PraiseSamuel-t8x
    @PraiseSamuel-t8x Pƙed 14 dny

    nice

  • @user-nk7bt8wv8p
    @user-nk7bt8wv8p Pƙed 14 dny

    Thank you for a fantastic educational video! Simple and concise! You are awesome.

    • @SharonSmith
      @SharonSmith Pƙed 13 dny

      Thanks so much for watching! Glad you liked it!

  • @jeannettekelbaugh3216
    @jeannettekelbaugh3216 Pƙed 14 dny

    Great instruction. I do have a question on the conditioning formula how do you know what to enter? I copied your formula and it's not working.

    • @skjones91199
      @skjones91199 Pƙed 14 dny

      She stated in the video that you need to buy the template from her online site if you want to get the entire formula.

    • @jeannettekelbaugh3216
      @jeannettekelbaugh3216 Pƙed 14 dny

      @@skjones91199 I thought the screenshot showed the formula. I figured part of it is cut off when it wasn't working.

    • @SharonSmith
      @SharonSmith Pƙed 13 dny

      Hello, here is the full conditional formatting formula you may be looking for: =OR(AND(DAY($C$10)=1, DAY($C10)>15), AND(DAY($C$10)=16, MONTH($C10)<>MONTH($C$10))) This works with the timesheet template and cell references from this video. Hope this helps. Thanks for watching!

    • @SharonSmith
      @SharonSmith Pƙed 13 dny

      Thanks for replying to this comment! I shared the entire conditional formatting formula in the pinned comments. It will work for the cell references in this particular timesheet template. Thanks for watching!

    • @jeannettekelbaugh3216
      @jeannettekelbaugh3216 Pƙed 8 dny

      @@SharonSmith thank you. You're videos have been so helpful. I did end up purchasing the templetes to save tiem. I am taking it a step further and adding the meal in/out.