Searching cells from user input

  • Thread starter Thread starter masanovic
  • Start date Start date
M

masanovic

Ive used Access to search a table and display results on a form but can this
be done in excel? For example, I want the end user to be able to enter "first
name" into a text box, and "Surname" into another. I want the rows in excel
to be searched and if they match the input to display that row in another
form.

Is this possible?
 
masanovic said:
Ive used Access to search a table and display results on a form but can this
be done in excel? For example, I want the end user to be able to enter "first
name" into a text box, and "Surname" into another. I want the rows in excel
to be searched and if they match the input to display that row in another
form.
Click to expand...

Excel has a data form in the Data menu.
The active cell must in in the Data table when you choose Data, Form.
You can search for records in the form

Peter
 
Back
Top