create a user form to allow for different search methods
 

hello all...i think what i'm trying to do is quite simple yet i dno't
know how to do it...so that's why i came to the experts!

i have a spreadsheet that has an enormous amount of information so i
want to create a userform which will allow the user to enter in search
criteria to find an order they are looking for.

for example....if they wanted to find all orders with a design pressure
between 3000 and 4500 or a temperature equal to 550 or (and this is the
one i'm really stuck on) search for the word "double" in the special
features...and then the output should show the user what orders fall
into their criteria

here is what my spreadsheet looks like (a condensed version)

Order Number pressure temperature Special features
050-33558 3300 100 double suction, no hydro
295-10581 2500 400 single suction
056-01200-01/02 5000 330 reduction gear


any help will be greatly appreciated!

THANKS!


--
jlm661
------------------------------------------------------------------------
jlm661's Profile: http://www.excelforum.com/member.php...o&userid=12424
View this thread: http://www.excelforum.com/showthread...hreadid=564756