View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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