Date and time field on the Last Updated column

[porabai]

Hello All

I have a spreadsheet. its being updated daily. I am in fix as I am trying to put at the bottom LAST UPDATED: and it should show me when the last time spreadsheet was updated.

I did it using date formula in the footer but it puts in that column the current date.

for eg: I modified the spread sheet on June 10, 2006 and I came back to work on June 14. The spreadsheet should show in the last updated column as June 10 and not as June 14.

Any idea/clue to how fix this problem. Your help will be truly and greatly appreciated.

thanks
Porabai

 

[Loomah]

Hi
First and foremost have a look at this faq707-1657.

One other thing to consider, what is your definition of updated? Is it when the sheet is changed or when it is saved?

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[porabai]

Thanks Loomah for the update. The definition for the updated i am looking for is when sheet is changed.

assuming i changed the sheet on june 10 and i opened it again june 14 the spreadsheet should show june 10 and not june 14.

put it this way: when the sheet is updated the date should reflect the date it got updated.

thank you

 

[Loomah]

In that case the FAQ I refer to is the way to go.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[porabai]

Hi loomah,

I am newbie in the visual basic but I am able to compile the event per FAQ707-1657 and was successful. I opened a sample excel spreadsheet and i am wondering how i have to correlate the vb script with the spreadsheet. I mean how can i get the last updated date stamp on the spreadsheet.

Your help will be truly appreciated.

Thanks
Porabai

 

[SkipVought]

hi,

What is your code doing whenever you make a change on your sheet?

Please post your code along with the expected result for a given change.

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}