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

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

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

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