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?

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?

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?

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?