how to automatically time update in a column

[vengatvj]

hi all,

i need a time update instead of pressing ctrl + shift ; i need a time when i enter details in another cell. i attached a example file. pls find and help me

[Fotis1991]

http://www.mcgimpsey.com/excel/timestamp.html

[vengatvj]

i dont understand about this site, can u please do it my excel and upload?

[Fotis1991]

The site explains step by step how to do this.

[vengatvj]

its not working, pls find this excel

[:) Sixthsense :)]

Do right click on sheet tab and select view code and paste the below code...

Return to excel and check...

Please Login or Register  to view this content.

[Fotis1991]

Did you follow this part of the instauctions?

..You can use a circular reference to enter the time when a change is made in another cell, then maintain that time. Choose Tools/Options/Calculation (Preferences/Calculation for Macs) and check the Iteration checkbox

Works great for me!!

[vengatvj]

THANK YOU FORTIS AND SIXTHSENSE, its working well. thank you very much..

[Fotis1991]

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.