I don't understand your "slow". How are you doing this. If using a macro
turn off calculationdo your thingturn back on. If desired, send your
workbook along with a COMPLETE explanation and before/after examples. Send
to my address below.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hong" wrote in message
...
I am trying this way, but it's too time consuming.

Thank you!

"Don Guillett" wrote:

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.