Hi, I would like to know if this can be programed.

I want to copy the list of parts numbers to Sheet2 but I want each different part number on a separate page.

Like on the file attached.

Any advise or help is greatly apreciated.

Sheets1.xlsx