Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching cells from user input
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching cells from user input
"masanovic" wrote:
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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Searching by an User Form | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Searching data in a column via Input Box | New Users to Excel | |||
Ask user for input during marco | Excel Discussion (Misc queries) |