Modified compare and delete across sheets

[drewship]

Hello again. StephenR provided this and after some testing, I found I needed to adapt it a bit. This compares cells in every sheet to a master sheet "AllUnits" and deletes all the matched rows on the Master. I modified it slightly to also delete the matched row on the source sheet as well (looking for rows that are not matched on any sheet). This works to a point, but I have to re-run it many times since when the source row is deleted, the code actually skips to the next row. I tried to reset the source variable with

Please Login or Register  to view this content.

in the hopes that it would allow the code to function, but it did not. I think it would work if the code started at the last row and went up instead of down, but I have not been able to figure it out.

Thanks in advance,
Andrew

Please Login or Register  to view this content.

[StephenR]

Andrew - modified slightly, you're right that it's better to start at the bottom and work up. This deletes everything though!

Please Login or Register  to view this content.

[drewship]

Thanks!! I hate to say it does everything I need because I will probably find another use for a modified version, but for the moment, it does everything I need. I now have a way to compare multiple sheets quickly to find discrepancies without the possibility of multiple duplicates confusing the issue.

You are most certainly a wizard!!