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.