VBA : Merging two lists

  • I have two lists with identical headers.

    Stock Price Yield

    the first list is my master list of information.

    The second list is new entries.

    I want to be able to combine the two lists, but only have one line for each stock... if there is a stock that shows up in the master list AND the new list, the values (for price & yield) in the new list should take precedence.

    I'm not sure where to start on this one... if it's a matter of writing a macro, or some type of advanced data filter, but I'm pretty sure it can be done.

    Thanks in advance!

  • Have you had a look at Data > Consolidation it may do what you want.


    There are three types of people in this world.
    Those who can count and those who can't.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!