Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to extract duplicated data from two seperate worksheets? | Excel Worksheet Functions | |||
Removing Empty Rows from Worksheets | Excel Discussion (Misc queries) | |||
duplicated in two worksheets with highlights | Excel Discussion (Misc queries) | |||
Duplicated rows | Excel Discussion (Misc queries) | |||
Duplicated rows | Excel Discussion (Misc queries) |