Help With Macro To Compare Sheets

[gaspower]

Hello,
As always, everyone is very helpful here and thank you.

I need help with a Macro to compare two sheets. Need to compare number in column "A" in sheet 1 and 2. If the number exists in both sheets, I need that row to output to sheet 3.

Thanks Jr

[MaczaQ]

Hello,

I wrote following code for solve your problem, I hope you will find it useful

Please Login or Register  to view this content.

In attached file you will find working example.

Best Regards

[gaspower]

Hello,

thank you very much. Seems to work fine. An error on my side when explaining. Column "A" is the identifier, but I also need to carry over column "B" which has the description.

Thanks JR

[MaczaQ]

Hi gaspower,

I don't want to be unpleasent but I wonder:
1. why you didn't attach any workbook with sample data
2. why you didn't give full description of what you need.

You expecting help from forum site but we can't still guess what you need.

Please write complete needs together with example workbook.

for copy data from column A and B change below use below part of code

Please Login or Register  to view this content.

MaczaQ

[gaspower]

Hello,

thank you. You are not unpleasant at all. You are correct. In the future I will follow your suggestions to make it easier. Completely my error in lack of description.

Thank you for your help.

JR