How do I include a macro or command button that when pushed will allow the
user to search the database for a given entry? For example, one page
contains all the pumps at a facility. The purchasing agent wants to search
for the pumps associated with "A" line. I want them to be able to push a
button that prompts them to input "A" line and it will search the spreadsheet
for that entry.

I know this is probably better suited for Access and am looking at that also
but excel is easier to teach someone to use.

Thanks