Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find fuction macro to look-up name
In an Excel sheet I have an employee list (Last name, First name, id#,
paylist...) I've need to create some kind of search box so that one can type in the last name, first name, or ID and will get a list of all criteria that matches. My table starts at B3 (last name) and ends at F3000 Does someone know how to do something like that or where I can find macro code for such a search function? Or could I create a Text box that would do the search for me? Any help is very appreciated Mel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find fuction macro to look-up name
Why not just use Filters instead. Data - Filter - AutoFilter... See if that
is close to what you want. -- HTH... Jim Thomlinson " wrote: In an Excel sheet I have an employee list (Last name, First name, id#, paylist...) I've need to create some kind of search box so that one can type in the last name, first name, or ID and will get a list of all criteria that matches. My table starts at B3 (last name) and ends at F3000 Does someone know how to do something like that or where I can find macro code for such a search function? Or could I create a Text box that would do the search for me? Any help is very appreciated Mel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find fuction macro to look-up name
The .find method is pretty useful for this.
-- http://HelpExcel.com " wrote: In an Excel sheet I have an employee list (Last name, First name, id#, paylist...) I've need to create some kind of search box so that one can type in the last name, first name, or ID and will get a list of all criteria that matches. My table starts at B3 (last name) and ends at F3000 Does someone know how to do something like that or where I can find macro code for such a search function? Or could I create a Text box that would do the search for me? Any help is very appreciated Mel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
find fuction macro to look-up name
On Feb 1, 12:01 pm, wrote:
I want to have it simple enough that one can open the spreadsheet while on the phone with a client, type in the name or ID number and click on search. Then we can see if we have them listed. If searching by name, the ID comes up and we can then search other data bases with that name. Mel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Min Fuction | Excel Worksheet Functions | |||
Which fuction! | Excel Worksheet Functions | |||
IF FUCTION | Excel Worksheet Functions | |||
For Each Fuction??? | Excel Discussion (Misc queries) | |||
Applying the find fuction to a button | Excel Programming |