0

I'm creating an employee time sheet for the year. I have tabs with each pay period (two weeks per pay period). I auto filled the first tab with the dates for that time period. How do I auto fill the other tabs with sequential dates going forward for the rest of the workbook? Seems tedious to enter first date and then drag down for each tab.

New contributor
JKRN is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
2
  • Keep in mind that we can't see your spreadsheet. We don't know your layout structure, your business or field, etc. So there isn't much we can say about how to do it unless you are able to let us in on the details.
    – Erik Tyler
    Jan 13 at 2:56
  • The one thing I can say, as someone who has been developing information systems with spreadsheets for decades, is that any time someone is setting up lots of tabs where the structure is repeated and only the data differs, my first thought is that this is not the best approach. You're trying to setup sheets ("tabs") as reports with manual data entry rather than setting up one database sheet and then using perhaps even just one tab with formulas to serve as a report that pulls data for the time period you want to see.
    – Erik Tyler
    Jan 13 at 2:57
0

Erik Tyler - Here is an image of the spreadsheet/workbook. Please let me know if you have a better way of doing this. I have each pay period tabbed at the bottom. enter image description here

New contributor
JKRN is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

JKRN is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.