Find and Remove Duplicates

[Mable]

I am currently working upon a workbook that consists of 9
worksheets. There is a master list of information, from
which the other 8 sheets were compiled. However, due to
the previous person's terrible foresight, I am now left
with duplicates upon every single sheet. What I would like
to do is write up a macro that checks the ID number of
each item against the Master List, and if it is found in
the master list, remove the entire row. Can anyone help?

The sheets are titled as follows:
Skid1, Skid2, Skid3...Skid7, Location Unknown, Old+Spare

Thanks.

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon
to flag duplicates. After this use Autofilter and delete the filtered
rows

 

[Mable]

This is exactly the kind of information I needed. Many
thanks.