Hello,

I have a excel sheet 1 with lots of data: part#, customer, quantity, date
......
I hava a list of some part#.

How can I copy the data from sheet1 according to the list of part#.
I can use filter, but it's too much time.
because for one part# in sheet1, there are lots of data.

Please help me.

Thank you in advance.