Thread: Extract data after a find in Excel 2003
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 Extract data after a find in Excel 2003
hi Dave

See this page for a code example
http://www.rondebruin.nl/copy5.htm

Try the first one
Below the macro you can read how you can do it manually with AutoFilter



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave" wrote in message ...
I have a spreadsheet that has 3100 rows of data. I did a Ctrl F and the find
returned 40 rows. How do I extract those 40 rows into a new spreadsheet?

Thanks
Dave
Reply With QuoteReply With Quote