Need to match one cell to another and paste row to new sheet

[CSIComp]

Any help is appreciated!

I'm a total novice at macros, but can muddle my way through. I have a workbook with product info on two sheets. I want to copy the rows of Sheet 1 and Sheet 2 if their A columns (Part Numbers) match. For example, on the sample file, A2 of Sheet 1 matches A2 of Sheet 2. I want row 2 (the matching row of each) to copy to Sheet 3. If this is too muddy, I'll be happy with copying only the row from Sheet 2 that has a matching value in Sheet 1, as Sheet 2 has about 3500 rows to Sheet 1's 250.


Sample.xlsm

Thank you, thank you, thank you in advance!

[JBeaucaire]

This should do it:

Please Login or Register  to view this content.

[CSIComp]

Thank you! It took a bit of tinkering to get it to work with the large workbook, which had quite a few more fields, but we got it done.
I really appreciate your help!

[JBeaucaire]

There you go, tinkering is always required. Cheers.

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.