find

[ash]

is it possible to add a find box in2 a sheet so that a
user can enter certain criterias and then they click
search and the computer searches thorough the data in the
workbook and then sends back all the results matching the
criteria?

 

[Dave Peterson]

In xl2002+, you can specify "within workbook" under the options button on the
find dialog.

In all versions, you could use Jan Karel Pieterse's FlexFind:
http://www.bmsltd.ie/MVP/