Copy / paste only specific rows

[Benjamin]

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?

 

[Ron de Bruin]

Hi Benjamin

If you install EasyFilter you can use "Begins with" and choose copy to a new workbook
http://www.rondebruin.nl/easyfilter.htm

 

[Benjamin]

This looks great, but it won't work with 2007?

Hi Benjamin

If you install EasyFilter you can use "Begins with" and choose copy to a new workbook
http://www.rondebruin.nl/easyfilter.htm

 

[Ron de Bruin]

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