VBA to update the date in my timesheet

[joeyheaf]

I have a worksheet that I am just toying with for my timesheet. I have a little macro where I press ctrl+n to create a new timesheet for a new pay period within the workbook. I am wanting it to update the new worksheet with the correct date (+1 day from the last day on the previous sheet) everytime I make a new worksheet. Also, If it could name the worksheet with those dates similarly to how I have the sheet named in the attached document. (not sure if this last part can be done).

[p24leclerc]

try this macro:

Please Login or Register  to view this content.

[joeyheaf]

worked great, nice little piece of code you wrote there. Thanks

[royUK]

Try this

Please Login or Register  to view this content.

Run the code with the latest sheet active

[royUK]

This will work providing the latest sheet is always the first tab

Please Login or Register  to view this content.

[p24leclerc]

RoyUK,
If the date in Q4 is the last day of the month, the next day will be the first day of the next month. Your programming do not take this into account, does it?

[royUK]

Try it & see. First day of period set to 18/03/11, so last day is 31/03/11. New sheet covers 01/04/11 to 14/04/11