jeffdolton
Board Regular
- Joined
- Dec 21, 2020
- Messages
- 100
- Office Version
- 2010
- Platform
- Windows
Good day,
I attach the workbook I'm working on test 1.xlsm
This is a simple timesheet. I would like a button on the current sheet to say “Create Next Sheet” or something similar. On clicking the button, the next sheet would then:
I attach the workbook I'm working on test 1.xlsm
This is a simple timesheet. I would like a button on the current sheet to say “Create Next Sheet” or something similar. On clicking the button, the next sheet would then:
- Be copied from the current sheet.
- Be renamed in the format DD-MM-YYYY for the next date in sequence, i.e + 7 days.
- The formulae for the blue cells in B1 and B6 to be updated to reference the previous sheet.