Thread: How do I assign hyperlinks to drop down menus in Excel(2007/2010)?

Hi,

I'm using the HYPERLINK function and finding it reliably useful. I'd value being able to assign hyperlinks (somehow) to individual menu drop downs(validation) in the other sheet.

I attached example file. (when i click on ice cream in main tab, I want to see ice cream in the drop box tab as well)