Compare 2 columns from different workbooks and copy non-matched data to another

[alanortega]

hello!

I have 2 worksbooks and i need to compare one column from workbook1 with another column from workbook2 and then I need to put the non-matched data into workbook3.

Is it difficult to do in a macro? i dont have an idea to do that

thanks for your help...

 

[CDICKENS]

It is not too difficult.

There are lots of examples of copying unmatched data with excel vba in google.

Find some code and try it out, we will be happy to work through any bugs or roadblocks you come across.

Chuck