TimeStamp

To be fully "automatic" would require the use of VBA. If that' OK, then:

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Right-click on the sheet tab and select VIEW CODE)
3. Copy and Paste in your code (given above)
4. Get out of VBA (Press Alt+Q)
5. Save as a macro-enabled workbook

The macro is installed and ready to use.

Originally Posted by JB

To be fully "automatic" would require the use of VBA.

Not sure I would quite agree with that assertion JB.

You could in theory also enable Iterative Calculation (via Excel Options) and then, assuming entry is in Col B with stamp in C, apply the below:

Please Login or Register  to view this content.

Also, should you prefer to have the ability to clear the stamp in C when deleting contents from B you can re-order the test accordingly:

Please Login or Register  to view this content.

Iterative Calculation (to allow for Circular referencing) is generally ill advised however so think carefully before implementing.

For a VBA approach I would be inclined to add an Events Toggle (with Error Handler) so as to avoid needlessly invoking the Event a second time.

My apologies, I have 0% experience using iterations, if that works in this scenario. Hard to remember options you never use. My bad.


I also added the event toggle as per your suggestions.

Originally Posted by AAKASH JAIN

...if we put "now" formula, then the time keeps changing whenever someone saves the file & it will shows the current system time.

Have you actually tested the formula with Iterative calculation enabled ?

Originally Posted by AAKASH JAIN

...not much aware of Iterative calculation

File Tab -> Options -> Formulas -> Enable Iterative Calculation (check) -> OK