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

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.
 
O

Otto Moehrbach

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
 

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

New computer, how do i move outlook 365 ENTIRELY? 0
How can I add diagonal lines like this? 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Need help modifying code 0
Synchronization problems while moving folders to new email 1
How do I clear a form? 0
DMax on existing record to increment serialized # fails 1
Extract Text in braquet and list of terms from 2 Docs 3

Top