Searching for specific text - how to

[spacia]

I have a master spreadsheet of 850 names (col A) and associated
unique
user ids (col B) which are all linked to other spreadsheets specific
to each name\ID. I would like to be able to add a search function to
the master spreadsheet so I can simply enter a persons name or ID and
jump to the corresponding cell in the master spreadsheet or have the
linked spreadsheet open. Can anyone offer a simple solution? Thanks
in
advance.

 

[timmg]

I have a master spreadsheet of 850 names (col A) and associated
unique
user ids (col B) which are all linked to other spreadsheets specific
to each name\ID.  I would like to be able to add a search function to
the master spreadsheet so I can simply enter a persons name or ID and
jump to the corresponding cell in the master spreadsheet or have the
linked spreadsheet open. Can anyone offer a simple solution? Thanks
in
advance.

Well, there's always Ctrl + F and looking at columns first. Very,
very simple and easy for users to get used to. The next option gets
more complicated by putting forms and vba over the search function.

Tim Mills-Groninger