Hello.

I´m trying to learn how to work with VBA, but right now im lost i have two workbooks with different data and i need to compare two columns in this case is column E (in file Test 1) against Column D (in file test2) if i find any matches i need to copy different cells for example in this case is cell B from the test1 file to Cell G and H and the columns of the sizes i need to transform it from 4 columns to just 1 column using a "," to separate the files. im uploading an example because sometimes is easier to see what im talking about than to explaining it.

Thanks for the help i really appreciate the help.

Gbest

test1.xlsx
test2.xlsx