![]() |
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. |
All times are GMT +1. The time now is 10:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com