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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching/Opening Userforms 0
Interactive Data Input Boxes 6
Popup Input Box 6
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Forcing User inputs 1
Protect cells but allow for user input. 3
Dynamic Excel data into locked Word form 0

Back
Top