Large scale
 

Hello all,

here is a query for you...

if i was to share a workbook, is there any VBA code that
would be able to check with existing workbook and inform
the user if any changes need to be made??

here is why....

each person on my workbook has a unique ID number (column
A) == if this number is repeated more than once then
there is a problem...because this ID is the number we use
to manually find the files.

what it needs to do....

if the ID number is already used, it needs to add the new
records (if the name field <column B is different) on the
end rows, thus increasing the size of the database.

OR

if the ID number is in use, and the name field is in use,
then it replases the existing record!!

thank you,

Robert Couchman
)