Save Today() in cell
Hi,
1. You could enter the date manually with Ctrl ; (control + semi-colon)
That enters the current data as a static number.
2. Otherwise you will need to use VBA because there is no way of making
TODAY() both static and dynamic at the same time.
3. Or After you copy the sheet you can manually go to the original sheet
(the old today) and copy Paste Special, Values.
--
Thanks,
Shane Devenshire
"3Nails" wrote:
I want to automatically save the current date in cell €śA1€ť. After saving the
sheet I will then copy the current sheet for tomorrows activity. I would
like the new current date to be automatically saved in the new sheet when
opened the next day. Basically have current date never change once it is
automatically updated in sheet. Any quick fix? Thanks€¦..
|