search

[Guest]

hi i want to put a search option in a spredsheet so you can enter 3 or 4
criterias and it will search a page or a few pages for all the results that
match the criteria, than it will return all the results to the 1st page, is
this poss.
please help
thank you

 

[Debra Dalgleish]

You can use an Advanced Filter to extract data to another sheet. There
are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

 

[Guest]

thank you for your help but this wasnt quite what i was looking for.
any more help please?????????????

 

[Dave Peterson]

Maybe you can live with Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

or maybe not.