Copy columns, remove duplicates and paste different worksheet and column query

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.

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3