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
|