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

Automatically filling cells froma different s
Pc restarts automatically - Guide
Transfer data from one excel worksheet to another automatically - Guide
Download automatically while roaming - Guide
How to open a web page automatically in full screen mode in html - Guide
How to automatically save photos from messenger to gallery - Guide

1 response

Answer 1 / 1

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

Similar discussions

help me to add particular cells

My computer turns off after 30 sec to 1 min

Comparing columns and returning value

Similar discussions

Subscribe To Our Newsletter!