Posted to microsoft.public.excel.programming

external usenet poster

Posts: 69

comparing lists in 2 workbooks and de-duplicating

I have 2 workbooks each containing long lists of names and addresses.

I need to compare the surname in column B and the first line of the address
in column D of workbook 1 with the list in workbook 2 (columns C and D). If
the same info occurs in workbook 2 I want to delete the entire line from that
list.

Can you help please?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel Duplicating Workbooks	luke1438	Excel Discussion (Misc queries)	1	August 11th 05 07:50 PM
Comparing two lists	halem2[_44_]	Excel Programming	0	October 15th 04 07:42 PM
Comparing Lists to Partial Lists	depuyus[_7_]	Excel Programming	0	August 5th 04 01:43 PM
COMPARING LISTS	jay dean	Excel Programming	3	June 11th 04 06:00 PM
Comparing 2 Lists	Glenn	Excel Programming	4	January 19th 04 02:07 PM

All times are GMT +1. The time now is 04:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us