Fill a column with the contents of another column based on a choic
 

Is there a _simple_ way to fill a column with data from a group of columns
based on a drop-down selection?

Lets suppose we have a empty column that we want filled with information
that is based on a quick drop down selection. The user chooses an item from
a Data Validation List, then a column fills up depending on whitch item the
user selected.

Example:
Drop down choices = numbers, letters, months
source data column A1:A12=1...12
source data column B1:B12=A...L
source data column C1:C12=JAN...DEC

It could be done with an if-then series, but there should be a simple way to
do it.

--
New to Excel

Fill a column with the contents of another column based on a choic
 

Yes. This should tell you how to do just what you need:
http://www.officearticles.com/tutori...soft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Sparky56" (removeparenthet icals) wrote
in message ...
Is there a _simple_ way to fill a column with data from a group of columns
based on a drop-down selection?

Lets suppose we have a empty column that we want filled with information
that is based on a quick drop down selection. The user chooses an item
from
a Data Validation List, then a column fills up depending on whitch item
the
user selected.

Example:
Drop down choices = numbers, letters, months
source data column A1:A12=1...12
source data column B1:B12=A...L
source data column C1:C12=JAN...DEC

It could be done with an if-then series, but there should be a simple way
to
do it.

--
New to Excel