Differences Between 2 Spreadsheets

**ZackG** · 02-23-2011, 02:45 PM

Hi all,

I have 2 spreadsheets. One is constantly being changed (rows being added or deleted) and I have one that is static.

Is there a way to flag or show the differences in each sheet?

I have posted an example of what is going on

**watersev** · 02-23-2011, 03:37 PM

hi, ZackG, are these changes (rows added or deleted) the only you need to monitor and what is the real data length in rows?

**ZackG** · 02-23-2011, 04:42 PM

Hi watersev,

Yes, these changes are the only ones I would like to monitor. The length of the row goes to Column L.

I hope that helps.

Zack

**watersev** · 02-24-2011, 03:27 AM

check attachment, run macro "NewRow". The code checks if the row is new by value in column B and C. If it's not enough I will amend the code to check by all columns till L

**lpg21051** · 08-19-2011, 09:14 AM

Hey, i used this macro to great effect.

however, in my case i also have row deletions in the changing sheet and when the macro gets to this point it begins to flag all records as new. looking at the code (not very up on VB) it looks like i may be able to change it to determine if the value in the static static sheet is no longer present in the changing sheet by doing a comparison, and resetting the loop value. i am going to work on it a bit, but if you have an idea, it would be appreciated.

oops, sorry. now that i look closer, it is not a row deletion problem. however, the macro begins to flag all records new at row 185. i will look further to see if i can figure out the problem.