How do I combine multiple columns remove duplicates and paste different worksheet & column

Hi

I have simple query for someone with advanced VBA knowledge. I have following macro to paste data in column A of destination sheet. I got it from: "http://www.mrexcel.com/forum/excel-questions/270724-unique-records-5-different-ranges.html"

Please Login or Register  to view this content.

I would however like to paste data in column C. I have tried to do this by changing the "A" value in second and third row of macro to "C". This seems however not to be sufficient. The macro has no effect. It does not copy and paste the data when I run it. Please note that my knowledge of VBA is very limited. Would appreciate if someone can just give me correct macro code.

Hi Greg

Thanks for your help. It works. I am trying to combine the code with another similiar code retrieving data from another sheet when I get an error for the last line of the second statement just above the sub statement. Here is the code I am trying to run. Do you mind checking if I am missing some code to combine the two codes?

Please Login or Register  to view this content.