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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top