Thread: Large scale
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Couchman[_4_] Robert Couchman[_4_] is offline
external usenet poster
 
Posts: 64
Default 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
)