Find and Remove Duplicates
 

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.

Find and Remove Duplicates
 

Hi
see:
http://www.cpearson.com/excel/duplic...tractingCommon
to flag duplicates. After this use Autofilter and delete the filtered
rows


--
Regards
Frank Kabel
Frankfurt, Germany

"Mable" schrieb im Newsbeitrag
...
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.

Find and Remove Duplicates
 

This is exactly the kind of information I needed. Many
thanks.
-----Original Message-----
Hi
see:
http://www.cpearson.com/excel/duplic...xtractingCommo
n
to flag duplicates. After this use Autofilter and delete
the filtered
rows


--
Regards
Frank Kabel
Frankfurt, Germany

"Mable" schrieb im
Newsbeitrag
...
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.

.