Tracking changes to formula results in cells

**dinkybluebug** · 02-11-2010, 05:35 AM

Hi,

I have a spreadsheet that looks up data from another worksheet.

I want to be able to see what values have changed when the sheet gets updated when I open it.

I know in excel I can use the TRACK CHANGES function, but this only tracks changes to values that you input manually yourself, such a data or formulas.

It wont track changes of formula results.

Is there any way of doing this? I currently have a sheet with 500 cells, and when the formulas update, I dont know what has changed from the previous save, as there is too much data?

Can anyone help

Marc

**martindwilson** · 02-11-2010, 07:14 AM

worksheet or workbook? probably the easiest would be to run a macro on close that copies the data to another sheet. then compare that to new data after its opened.
something in the workbook module along the lines of

Please Login or Register  to view this content.

probably easier would be to copy to the same sheet way off to the right then you could use conditional format quite easily to highlight changes

Please Login or Register  to view this content.

alternatively use before save instead

Please Login or Register  to view this content.

Tracking changes to formula results in cells

LinkBack

Thread Tools

Rate This Thread

Display

Tracking changes to formula results in cells

Re: Tracking changes to formula results in cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions