How can I add the new record from another list to current one?

  • Thread starter Thread starter PattyS
  • Start date Start date
P

PattyS

I receive updated lists from others and have used VLOOKUP to add a "closed
date" to an existing record, but I need to know if I can recognize if a
completely new record has been added to that list as well.

Currently, I just do a side by side comparison and cut & paste when a new
line is found.
 
Patty
Yes, you can do that with VBA. If your records, new and old, have an
identifier such as an account number, serial number, ID, anything, VBA can
search the new list for each identifier in the old list, and do whatever you
want if a new record is found. If you want to pursue this, provide as much
information as you can about the layout of the old records and the new
records, such as what workbooks have what, what sheets have what, what is in
what columns, etc. HTH Otto
 
Back
Top