| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy data
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy data
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy excel data (inc. textbox data) into Word | Excel Discussion (Misc queries) | |||
| filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
| Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
Linear Mode
