Timestamp/Date Formula

[mcmuney]

I need a timestamp and/or date formula that will auto update when a cell is updated. For example, this formula will be on columnB referencing columnA. If A1 is updated, B1 will update automatically with the date when it was updated. This will happen every time A1 is updated. B2 will update when A2 is updated, etc.

Is this possible?

[Palmetto]

You would need to use VBA due to the fact that the TODAY() function is volatile and can change each time the worksheet recalculates.

If you put this code in the worksheet module, it will update B-cells with the current date & time only when the adjacent A-cell is changed.

Please Login or Register  to view this content.

[mcmuney]

I added your VBA code and used "NOW()" formula on columnB. But it doesn't seem to work. When any cell is updated, the whole columnB updates.

Am I doing something wrong?

[shg]

The code is used IN LIEU OF a formula in column B, and must go in the sheet module. Right-click on the sheet tab, select View Code, and paste the code in the windo that opens, then Alt+Q to close and return to Excel.