2009/11/28 bill purvis <[email protected]> > On Saturday 28 November 2009, Michael Adams wrote: > > On Fri, 27 Nov 2009 19:43:23 +0000 > > > > Came this utterance formulated by bill purvis to my mailbox: > > > 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! > > > > I understand that you are not looking for the date and time of the last > > sheet-recalculation. But are you looking for the date when the file was > > last saved, when a formula was last modified or when content was last > > updated? > > > I am refining my thoughts on this. What I really want is to be able to > load the spreadsheet and print off a copy and know when I last modified > it. I am now thinking that the last time I saved it is sufficient for that > purpose and I am about to start looking at using a script, invoked by > the 'Save' event to update the cell. If you have any better ideas, I'd > welcome them. > > I think that if you put the date/time in the Header/Footer it will change every time you save the document and automatically print correctly. Menu Edit>hearer/Footer and then click the Date icon, type a couple of spaces and then click the Time icon. Of course you can add text as well and position [pieces of] the header/footer left, center and/or right
-- Harold Fuchs London, England Please reply *only* to [email protected]
