Extract data after a find in Excel 2003
 

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

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

Extract data after a find in Excel 2003
 

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

Dave

"Ron de Bruin" wrote:

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

Extract data after a find in Excel 2003
 

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



--

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


"Dave" wrote in message ...
The find was for the entire sheet, searching all the columns. I should have
said that earlier

Dave

"Ron de Bruin" wrote:

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

Extract data after a find in Excel 2003
 

Could you do a DataFilterAutofilter 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

On Mon, 7 Apr 2008 13:20:06 -0700, Dave wrote:

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