nightracer
Board Regular
- Joined
- May 17, 2004
- Messages
- 147
- Office Version
- 365
Hi
At various points during the day I run a macro to take a copy of a worksheet to show work processed up to that point in the day.
So I start the day with the single sheet that takes in the data and then by days end I might have 6 sheets in the workbook, having taken 5 snapshots during the day.
Is it possible to timestamp those worksheets with the date/time (or just time if easier) they were created as the sheet tab name?
Many thanks, hope that makes sense.
Nightracer
At various points during the day I run a macro to take a copy of a worksheet to show work processed up to that point in the day.
So I start the day with the single sheet that takes in the data and then by days end I might have 6 sheets in the workbook, having taken 5 snapshots during the day.
Is it possible to timestamp those worksheets with the date/time (or just time if easier) they were created as the sheet tab name?
Many thanks, hope that makes sense.
Nightracer