two databases, only display info if NOT in each list

J

jrozendaal

i have two worksheets showing people's info (DB1 & DB2):

A B C D E
F G
1 First Last Address 1 Address 2 City State Zip

2

3


on the third worksheet (DBmail), i only want to display mailing
addresses if the contact is NOT listed in BOTH DB1 & DB2. So if
sally's info is on DB1 and not on DB2, show her info. if Sally is on
both lists, do not show her info.

Let me know if you need any further clarification.

Any help is greatly appreciated! Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down lists in seperate columns 5
Menu Macro Not Executing - Need Help 1
listing records from 2 database tables even if there are no values inone table 2
Help with show info on one row in Excel 2007 0
Form /subform question 1
Creates db1, db2 on "compact on close" 11
Creates db1, db2 on "compact on close" 13
Reference to adodb.connection (or objects in general) 1

Top