copy data

[Hong]

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.

 

[Don Guillett]

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

 

[Hong]

I am trying this way, but it's too time consuming.

Thank you!

 

[Don Guillett]

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