View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RCSZEW RCSZEW is offline
external usenet poster
 
Posts: 1
Default Removing rows when duplicated in 2 worksheets

This is the first time I have used excel for anything like this and I am
really struggling with formulas or trying to set up a macro for this. I am
using Excel 2003.

I have 2 worksheets A & B each containing names (Column A) and address
information (Columns B through to I). I need to delete all of the rows of
data in "Worksheet A" which appear in "worksheet B". To complicate this
though, the whole row must be compared as sometimes names are the same but
the address is different, so these are not duplicate record.

Any advice as to how I should go about this would be really appreciated!
Thanks.