S
Sparky56
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.
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.