When a cell content changes, automatically keep a record with date in a seperate worksheet

[d-j-s]

Hi,

I have a cell ( M225 ) in Sheet 1 which is called 'OVERVIEW'.

The cell value changes regularly as it is a sum of other cells in the worksheet.

I want to somehow keep a record of the cell every time it changes in a worksheet I have called 'VOLUME RECORD' with the date next to it.

Is this possible?

Regards,
David

[:) Sixthsense :)]

Copy the below code and do right click on OVERVIEW sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

[d-j-s]

Wow,

Works a treat!

Thank you very much.

[JasperD]

Sixthsense's solution is awesome, with the downside that it will keep a record if a calculation is done, rather than when that specific cell changes...

@Sixthsense: Would adding something like below not make sure it only records when there's a change?

Please Login or Register  to view this content.

[:) Sixthsense :)]

@Sixthsense: Would adding something like below not make sure it only records when there's a change?

Thanks for the correction Jasper. Yes the change event is enough, I believe

Please Login or Register  to view this content.

[JasperD]

@ Sixthsense : the change event won't trigger a sum calculation change, so your original approach was better.
Just adding in to see if the value actually changed by the line that I added would make it complete, I think.

Anyway, this thread is marked as solved, so I guess it worked ;-)