Every week, I have the task of running a report and using
a Vlookup to check if the row exists. I run a report
every week that I want to compare 3 pairs of excel
sheets. Each week I will compare the sheets, one would be
current and the other would be a week old. The current 3
pairs should not have any of the rows of the previous
week's 3 pairs nor should there be any row the same
between the current 3 pairs. I would appreciate is
someone could assist with a macro that will first compare
each pair against its previous week. It would check the
first value in a1 empeeID against the previous week
always using column A for comparison. if it finds the same
row, delete (or highlight) the entire row. Any new values
existing in the current would be saved to a new book. this
would continue for the next 2 pairs. then it would open
the now 3 newly saved workbooks and check column a for any
duplicate rows between them. As before, any duplicates
delete, new values saved to a single new sheet. I hope
this is clear. please post for additional clarity
Many thanks in advance
E. Grayham