Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to extract duplicated data from two seperate worksheets? simon steel Excel Worksheet Functions 4 January 9th 08 09:36 PM
Removing Empty Rows from Worksheets Gareth - Network analyst. Excel Discussion (Misc queries) 2 August 8th 07 09:59 PM
duplicated in two worksheets with highlights Pammy Excel Discussion (Misc queries) 1 January 23rd 07 05:00 AM
Duplicated rows cj21 Excel Discussion (Misc queries) 1 August 18th 05 04:14 PM
Duplicated rows cj21 Excel Discussion (Misc queries) 1 July 29th 05 01:55 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"