Help with formula needed to apply current date when balance changes

[manyounited]

Hi all

I have attached a sample of my spreadsheet, in it I want the date cell to show the current date but only when the amount is altered in that corresponding row.

i.e

If the amount changes up or down in colomn A2 then F2 displays the current date on which it was changed.

I have searched the site and I only found "DATE STAMPING" which is not what I'm after.

I would appreciate any help or advise

Many thanks

[Dav]

The only way to do it is with a macro. I have added the following to the Sheet1 tab in VBA

Please Login or Register  to view this content.

Does that help?

Regards

Dav

[manyounited]

Dav,

Many thanks for your reply, the macro works in the sample but I don't understand how to adapt the code for other purposes.

For example, the sample spreadsheet I uploaded was a cut and paste section of a working spreadsheet I have but in the working sheet the balances are in column "I" and the dates are in column "N", and this code doesn't work.

I would appreciate it if you could explain how to alter the code to suit my application?

Thanks

[Dav]

well if you go to the code

open spreadsheet

press alt F11 to bring up the vba window

double click on sheet1 to bring up the code

if you see where it says columns("A") just replace the A with an I. The date column is still five columns to the right so the offset function does not need changing

Regards

Dav

[manyounited]

Dav you are an absolute starr, thank you very much for your help and patience.

Manu