Extract data after a find in Excel 2003

[Dave]

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

 

[Ron de Bruin]

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

 

[Dave]

The find was for the entire sheet, searching all the columns. I should have
said that earlier

Dave

 

[Ron de Bruin]

Hi Dave

The find was for the entire sheet, searching all the columns. I should have
said that earlier

You can start with this basic example and adapt it to copy rows
http://www.rondebruin.nl/find.htm#Copy

 

[Gord Dibben]

Could you do a Data>Filter>Autofilter for the same criterion then cut the
visible rows and paste to other sheet?

If your "found" data is in multiple columns you would have to make a couple or
three passes?


Gord Dibben MS Excel MVP