Compare 2 rows of data and update the first

B

BobC

I have 2 lists both have the same data in each (account names). Th
first list is the master and the second list is a new accounts list.

I would like to compare the second list to the first one and if th
account is not in the first list then I would like it added to list 1.

The second list changes frequently so I am looking to automate thi
process.

I am able to do vlookups to check for matches but I am unsure of how t
perform the additional tasks of updating.

Is there a simple solution with formulas or do I need to insert
macro/program?

thank you for your time and help,

Bob
 

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
dependent, multiple variable, drop down list 2
Macro Pause to Select range then Subtotal 0
Setting up a chapter a word-count inventory for a novel 1
Need to create a list of non-duplicates 1
Using checkbox to change cell color 2
Counting Days 2
Comparing two lists in Excel 1

Top