View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael E.[_2_] Michael E.[_2_] is offline
external usenet poster
 
Posts: 2
Default Comparing 2 excel files

A small correction:
same addresses have same 7-digit number in column A
Kind regards
Michael E.

"Michael E." wrote:

Hallo,

I have the following problem

For a mailing-campaign I use an excel file (file "A") with ca. 5000
addresses. Each row contains one address, in column A there is a special
number (7 digits) for each person.

A second file (file "B") contains 1000 addresses some of which are also in
file "A". People in file "B" should not receive the mailing.

Goal: a new file "A" where those addresses are deleted that are included in
file "B". Both files have identical structures (1 address in 1 row; some
addresses have same 7-digit-number in column A)

Any solution for this problem?

Kind regards

Michael E.