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
Download automatically while roaming - Guide
Why does facebook refresh itself automatically - Guide
How to automatically save photos from messenger to gallery - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to open a web page automatically in full screen mode in html - 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

Why does our account keep randomly following additional users every few weeks?

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!