Copy and paste matching rows to a new sheet

Hi All

I have a list of part numbers in a worksheet called �List of Reviewed� in column A (with a header line in A1)
This list can be from 20 to 100+ part numbers long.

These part numbers will match a master list with multiple entries in a worksheet called �Master� column C (with a header line in row 1).

I would like a VBA code to search each of the part numbers from the sheet called �List of Reviewed� from A2 down to the last part number and copy and paste all matching rows in the worksheet called �Master� into a new worksheet including the header line in row 1.

I have search but can not find a way to do this, can anyone help please.

Thank you

Could be done with a 365 formula.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Read the instructions regarding the SIZE of the sample data again, and also what it says about EXPECTED RESULTS.

Amend the sample workbook accordingly and reattach.

You could try this:

=DROP(REDUCE(0,A2:A19,LAMBDA(x,y,VSTACK(x,FILTER(Master!A:X,Master!C:C=y)))),1)