Add new entry to list
 

I have a list of customers, and what i want is a macro to check the current
entry against the list. If the entry is not found in the list, i need it to
be added to the bottom. If it is found in the list, just ignore it.
Thanks!
Jeremy

Add new entry to list
 

It may be easier to import both spreadsheets into Access and use its
find unmatched wizard query builder. Another option (there are
probably better ones), would be to copy all of the list over to one
excel spreadsheet, then type in the following formula which will check
for any duplicate entries.
=if(countif($a$1:a1,a1)1,"Duplicate,"Unique")
This assumes that the unique customer ID is in column A. Once you know
which are duplicate, you will want to copy these values (not the
formulas) over to the next column so you can sort the list
alaphbetically so all your duplicate ones are grouped and all the
unique ones will be grouped. Now that you have all the unique ones,
you know these are the ones to keep. As I mentioned, I am a beginner
so there are probably better options, but I think this would work.

-Andrew V. Romero

Add new entry to list
 

I don't know what is going on, but I answered this question early this
morning and the post hasn't arrived. Maybe my work has blocked
newsgroups...anyway...my idea is sort of a work around for your
problem. I am still new at complex formulas, so there maybe another
way to do this, but I would...
-Copy both list into one worksheet.
-Use the following formula to determine if the entry is a unique or
duplicate
=if(countif($a$1:a1,a1)1,"Duplicate","Unique")
Convert or copy the formula values (not the formula- edit paste
special) over to another column, then sort by that column. All the
Unique entries will be at the bottom, thus you now have a list of only
unique entries.

-Andrew V. Romero