Compare Sheets In Workbook Copy To Sheet Three

[gaspower]

Hello,

I have a workbook with sheet1 and sheet2. One sheet has data in column A, B and C. Column A is the identifier to be compared on both sheets. I would like to compare column A and if like between both sheets highlight green copy sheet1 column A&B to sheet3, plus copy from sheet2 column B to sheet3 column C. I do need to carry over the column headers, but column order is not important. Please see example of Excel. Also I have below the start of the Macro I think?

Please Login or Register  to view this content.

Thanks JR

[AB33]

Try the attached.

[gaspower]

Hello AB33

Thank you for the reply. I tried to run the file Alt + F8, but does not seem to run. Sorry did I mis something? I appreciate the help.

JR

[oeldere]

excel 2013 => view => macro => run macro => matchTwosheets

[gaspower]

Hello,

Thank you Thank you. All works perfect.

JR