I think?? you may want to SORT and then copy. Or. copy all and then sort the
destination.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hong" wrote in message
...
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.