bill purvis wrote:
On Friday 27 November 2009, Andreas Saeger wrote:
bill purvis wrote:
I am working on a multi-sheet parts list spreadsheet and it would be
really useful if I could automatically insert the date of the most
change at the bottom of each sheet. I can see that I can enter the
'current' date, but I'd really like the date at which any of the sheets
were last modified. At present I have a hidden field on sheet1 and
copy this to all the relevant cells, but then I have to unhide the
cell, update the content, and re-hide it each time I change something.
Is there such a function - I couldn't see it in the help list.
Bill
Type the address or name of the cell into the name box left of the
formula bar.
Then type into the formula bar: =NOW() F9 Enter Enter
No good! I want to be able to open the spreadsheet and see when it was
last modified - NOW() gets updated when you load a SS, otherwise it would
be the answer. Thanks anyway!
Bill
Bill: Did you actually try his suggestion? I just did, and it does NOT
update when you save and then re-open the file.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
