copy data

  • Thread starter Thread starter Hong
  • Start date Start date
H

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.
 
I think?? you may want to SORT and then copy. Or. copy all and then sort the
destination.
 
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.
 
Back
Top