| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy / paste only specific rows
I have a list of parts that begin with certain letters (B,N,V,etc) with
additional information (price, qty, size). Is there a Macro to copy only the rows that start with N (example of parts are N11, N12, NP16, NX10) and paste them into another workbook? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy / paste only specific rows
Hi Benjamin
If you install EasyFilter you can use "Begins with" and choose copy to a new workbook http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Benjamin" wrote in message ... I have a list of parts that begin with certain letters (B,N,V,etc) with additional information (price, qty, size). Is there a Macro to copy only the rows that start with N (example of parts are N11, N12, NP16, NX10) and paste them into another workbook? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy / paste only specific rows
This looks great, but it won't work with 2007?
"Ron de Bruin" wrote: Hi Benjamin If you install EasyFilter you can use "Begins with" and choose copy to a new workbook http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Benjamin" wrote in message ... I have a list of parts that begin with certain letters (B,N,V,etc) with additional information (price, qty, size). Is there a Macro to copy only the rows that start with N (example of parts are N11, N12, NP16, NX10) and paste them into another workbook? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy / paste only specific rows
This looks great, but it won't work with 2007?
I am working on a new version now But you can use AutoFilter to filter and use Begins with Then copy the visible cells to a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Benjamin" wrote in message ... This looks great, but it won't work with 2007? "Ron de Bruin" wrote: Hi Benjamin If you install EasyFilter you can use "Begins with" and choose copy to a new workbook http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Benjamin" wrote in message ... I have a list of parts that begin with certain letters (B,N,V,etc) with additional information (price, qty, size). Is there a Macro to copy only the rows that start with N (example of parts are N11, N12, NP16, NX10) and paste them into another workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy, Paste in a specific format | Excel Discussion (Misc queries) | |||
| Copy/Paste Rows | Excel Worksheet Functions | |||
| COPY AND PASTE SPECIFIC ROWS | Excel Discussion (Misc queries) | |||
| Copy/Paste Rows that Contain Specific Text | Excel Worksheet Functions | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
Linear Mode
