Creating drop down list that auto fills multiple cells

  • Thread starter Thread starter amber
  • Start date Start date
A

amber

I want to be able to select an item from a drop down list that then fills in
several cells in a column. I would prefer the data be on a separate worksheet
so it's hidden.
 
one way

first create a name for your data on the seperate to be hidden worksheet
say you call it mylist.
Then have one cell (D2 for instance) on the main sheet with
<data><validation>allow list
in the <source> enter =mylist

all the other cells you want to update at the same time could have the
formula =D2
 
Thank you Bill but it's not exactly what I am looking for. Let's say for
example I have a list titled: Apples, in the cells below I have descriptions
of apples: red, round, edible, etc. I would like to creat a drop down that
when I choose Apples, it fills the cells below with my list of descriptions.
Is that possible???
 
Don, was there something specific on that website that would help me? There's
a lot of information there but I don't know what/if any would help solve my
dilemma.
 
Fish around. She is the "god" of dropdowns. There are explanations and
examples of what you want with downloadable workbooks.
 
Back
Top