View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sparky56 Sparky56 is offline
external usenet poster
 
Posts: 1
Default 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