Searching for specific text - how to

  • Thread starter Thread starter spacia
  • Start date Start date
S

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.
 
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.
Click to expand...

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
 
Back
Top