| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I could not find XML in Excel 2003 Data | Excel Discussion (Misc queries) | |||
| Find a worksheet and extract data | Excel Worksheet Functions | |||
| chinese data extract from Oracle 9i to Excel 2003 | Excel Discussion (Misc queries) | |||
| find a worksheet and extract data | Excel Worksheet Functions | |||
| Excel FIND ALL-How do you extract the findings to a new worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
