Thread: Copy / paste only specific rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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?
Reply With QuoteReply With Quote