I am trying to create a spreadsheet that has a drop down list with selections
that lead to an even larger list. For example, In my list you could select
sweater. It would then Hyperllnk (or just link) to a different sheet where
they can select from multiple colors. Selecting would insert that color
(word) into the original cell. Thanks ahead of time for helping...

Maybe you could use dependent data validation lists, instead of
hyperlinks. There are instructions he

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

iamgpop wrote:
I am trying to create a spreadsheet that has a drop down list with selections
that lead to an even larger list. For example, In my list you could select
sweater. It would then Hyperllnk (or just link) to a different sheet where
they can select from multiple colors. Selecting would insert that color
(word) into the original cell. Thanks ahead of time for helping...


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html