need help with designing an excel macro!

[yorkerguru]

I have two reports with 10 and 10 columns each. I need to copy data from "A,C,E and F" and "A,C,D, and F" columns respectively from Sheet 1 and Sheet 2 to be entered to another report to find out mismatch. How should I do this?

 

[Special-K99]

Since you only have 10 rows and 10 columns why don't you just use formulas?

=Sheet1!A1 =Sheet2!A1
=Sheet1!A2 =Sheet2!A2
etc

 

[yorkerguru]

these two sheets are outside the report I create. To elaborate: I'm doing a reconciliation report which would require these columns to be copied and pasted manually from two different excel sheets. So, I want a macro to do this rather than I'm manually pasting it from the two different excel sheets.