If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I add the new record from another list to current one?
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. |
#2
|
|||
|
|||
How can I add the new record from another list to current one?
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 "PattyS" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|