Excel FIND ALL-How do you extract the findings to a new worksheet
 

Using the 'FIND ALL' option in excel brings a box of seletions based on my
search criteria. I would like to take those findings and make a new Excel
worksheet with them.

Excel FIND ALL-How do you extract the findings to a new worksheet
 

It's not possible using that dialog.

But you could write your own code -- or even use an addin that's very nice--
Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

BelAir wrote:

Using the 'FIND ALL' option in excel brings a box of seletions based on my
search criteria. I would like to take those findings and make a new Excel
worksheet with them.

--

Dave Peterson

Excel FIND ALL-How do you extract the findings to a new worksheet
 

It makes a difference if the matched cells will all be in the same row or
column versus scattered all over the worksheet.

If they are scattered all over the worksheet....we need more information to
be able to help....particularly, what the rules are.

If they will all be in the same COLUMN or ROW and you only want the matched
cells copy/pasted:
EditFind...[Find All]
[Ctrl]+A (to select all matches)
Press [Escape] 1 time to clear the find screen
EditCopy
FileNew
Press [Enter] to past the items.

If the matched cells will all be in the same COLUMN and you want the
associated cells from the SAME ROW to be copied, you'd do better to use a
Data Filter to select the cells before copy/pasting.

If the matched cells will all be in the same ROW and you want the associated
cells from the same COLUMN to be copied, you could:
EditFind for the cells that DO NOT meet your criteria...then..
FormatColumnHide
EditGoTo...[Special Cells]...Current Region......[Enter]
EditGoTo...[Special Cells]...Visible Cells only....[Enter]
Then copy/paste where you want.

Does that give you something to work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"BelAir" wrote:

Using the 'FIND ALL' option in excel brings a box of seletions based on my
search criteria. I would like to take those findings and make a new Excel
worksheet with them.

Excel FIND ALL-How do you extract the findings to a new worksheet
 

Belair

After you have done the "Find All" step you are presented with a dialog box
with found items.

Click on top item then hold SHIFT key and scroll down to last item using
downarrow. Click on that to select all.

You will see these cells selected on your sheet.

Close the dialog and EditCopy.

InsertWorksheet. Select A1 and Paste.


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 08:27:04 -0800, BelAir
wrote:

Using the 'FIND ALL' option in excel brings a box of seletions based on my
search criteria. I would like to take those findings and make a new Excel
worksheet with them.

Excel FIND ALL-How do you extract the findings to a new worksheet
 

It would be a very useful to me as well, but unfortunately neither of
the above solutions seem to work, I'm using Excel 2003 on windows XP.


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=494912

Excel FIND ALL-How do you extract the findings to a new worksh
 

Thank you, is there a way to grab the entire row and have that copied?
Assuming that your original worksheet has ove r700 entries and your 'found
items' equal approx 150.

"Gord Dibben" wrote:

Belair

After you have done the "Find All" step you are presented with a dialog box
with found items.

Click on top item then hold SHIFT key and scroll down to last item using
downarrow. Click on that to select all.

You will see these cells selected on your sheet.

Close the dialog and EditCopy.

InsertWorksheet. Select A1 and Paste.


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 08:27:04 -0800, BelAir
wrote:

Using the 'FIND ALL' option in excel brings a box of seletions based on my
search criteria. I would like to take those findings and make a new Excel
worksheet with them.

Excel FIND ALL-How do you extract the findings to a new worksheet
 

I tested my method on one column only and it works.

BUT..........Does not work if data is in more than one column.

Get the "cannot be used on multiple selections"


Gord


On Tue, 20 Dec 2005 11:37:50 -0600, tghcogo
wrote:


It would be a very useful to me as well, but unfortunately neither of
the above solutions seem to work, I'm using Excel 2003 on windows XP.

Excel FIND ALL-How do you extract the findings to a new worksh
 

Belair

I tested this method on one column only and it worked.

When data is found in more than one column it errors out with the "cannot do
this on multiple selections".

Poor testing leads to poor advice<g

See Ron's suggestion on using Filter.


Gord

On Tue, 20 Dec 2005 09:52:02 -0800, BelAir
wrote:

Thank you, is there a way to grab the entire row and have that copied?
Assuming that your original worksheet has ove r700 entries and your 'found
items' equal approx 150.

"Gord Dibben" wrote:

Belair

After you have done the "Find All" step you are presented with a dialog box
with found items.

Click on top item then hold SHIFT key and scroll down to last item using
downarrow. Click on that to select all.

You will see these cells selected on your sheet.

Close the dialog and EditCopy.

InsertWorksheet. Select A1 and Paste.


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 08:27:04 -0800, BelAir
wrote:

Using the 'FIND ALL' option in excel brings a box of seletions based on my
search criteria. I would like to take those findings and make a new Excel
worksheet with them.