Using Excel link (hyper?) and list functions

[iamgpop]

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]

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

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