Creating drop down list that auto fills multiple cells

[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.

 

[Bill Kuunders]

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

 

[amber]

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 Guillett]

http://www.contextures.com/tiptech.html

 

[amber]

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.

 

[Don Guillett]

Fish around. She is the "god" of dropdowns. There are explanations and
examples of what you want with downloadable workbooks.