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.
|