Automatically filling cells froma different s

Closed
shamtembo Posts 1 Registration date Thursday March 11, 2010 Status Member Last seen March 11, 2010 - Mar 11, 2010 at 02:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 10:53 AM
Hello,
I have a small problem with excel 2007 which i cant seem to figure out.
I have a table of data which contains data like the one below for several hospitals:

Hospital Name, Hospital Number, Contact Person

etc in one row but each in different cells. now what i need is that when i create a drop down list and select a hospital name, the other details like contact person etc are filled automatically in the adjacent cells vertically in a different sheet. eg

Hospital name
Hospital Number
Contact person

please help

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 11, 2010 at 10:53 AM
Could you post a sample file along with how do see things happening ?
you can post it at https://authentification.site or some other site
0