Compare 2 lists adding missing data from 2nd list to bottom of 1st list.

  • Good day Ladies and Gents,


    I have 2 lists on 2 sheets. Each list is thousands of rows long.



    What I need to do is loop through each Name in List2 Sheet2. And look for it in List1 Sheet1.


    If a match is found then do nothing "Goto Next Cell" if Not..Then add it to the bottom of List1.


    I just can't seem to wrap my head around this.

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Compare 2 lists adding missing data from 2nd list to bottom of 1st list.


    Sledgehammer approach... there's probably more elegant ways to do this but it sounds like a one off...


    Made up two lists with nearly 1,500,000 items with 15 missing from list1 - it took nearly a minute to run but I think my list is bigger than yours, and as mentioned, it sounds like a one-off :)

  • Re: Compare 2 lists adding missing data from 2nd list to bottom of 1st list.


    Thanks Cytop, I will give it a whirl :)

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

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