Finding Updated Rows

[DZI91]

Hi All,

Would really appreciate some help with a problem I'm having at work. Every week or so we have been creating a summary sheet for a due diligence process, which contains all the data on all the documents we have reviewed. Each week we add new rows to the sheet, but occasionally one of the higher ups will update one of the previously reviewed rows (because someone made an error). The client is asking us to flag which rows have been updated.

Essentially the problem I have is I have a spreadsheet with c. 600 rows in it, which contains new data, old data, and updated old data, and another two spreadsheets from earlier this month which contains less up to date data.

Does anyone have any clever ideas on how I could find out which rows have been updated since the previous spreadsheets?

Thanks all!

Dan

[kev_]

On easy way
Test in attached woorkbook

The value in cell A1 determines the row numbers that you are interested in

In week 1 we want to know about rows 1 to 30. So A1 = 30
Amend anything in any cell in any row up to and including 30 and the cell in column A turns red

At beginning of next week, clear red cells and amend the value in A1 to 40 etc

Code in sheet module:

Please Login or Register  to view this content.