Copy / paste only specific rows

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

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?
 
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
 
Back
Top