adding a name to a list if it does not already exist

Hello,

I am looking at a column of names (the source), and if one of the names from source is not in a different list (master) I want to add it to that list (master).

My logic seems to make sense, but I think I am getting stuck on the loops. In my outer loop (j), I am temporarily storing each name as a dummy variable (source_name). I am then looping through each of the names in the other list (the x loop). If they match, then end this "for" loop and go on to the next name in the source. If they do not match, check the next name in the master. When it has checked all of the master names against the source name and there is still no match, it will enter the source name in the first empty row in the first column.

Is it possible that my "End for" is ending my outside loop instead of my inside loop? It keeps telling me that I have a next without a for, so I think that may be my problem.

Is there a way to let the program know which for loop I would like it to end?

Please Login or Register  to view this content.

Maybe I am just looking at this incorrectly, but it seems like it should work.

Any suggestions?

Also, can you exit an internal for loop and go to the next iteration of the outside loop? That is essentially what I am doing.

Thanks,
Shannon

can you upload a workbook with the layout of your workbook and show where you want the results to be placed?

See if you can adjust this to your needs

Please Login or Register  to view this content.

It would of been nice to know that the source names are coming from another workbook! Are both workbooks open when your running this Macro? If so try this. Change Book1.xlsx for you needs.

Please Login or Register  to view this content.

Ok glad you got it working.

Ok Shannon, no problem.