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