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.