An example added.
I used Named Table there.
On sheet Report, user can select any person registered on Data sheet, and it's LogIn and password are displayed automatically.
Btw. Having multiple sheets with same kind of information is a bad idea - when the info from those must be read to another sheet, you have to redesign your workbook every time a new name is added. E.g let's assume you have another sheet with table, where services those persons are offering are registered - like
tPersonServices: PersonName, ServiceID
And another table on another sheet - like
tServices: ServiceID, Service
Now on Report sheet, whenever you select a person, you can automatically get a list of all services this person is offering (using formulas which read info from those tables - you have to prepare a table for it with enough rows to get services for any person).
|