View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mable Mable is offline
external usenet poster
 
Posts: 2
Default 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.