Hyperlink List

I have a seperate worksheet for everyday of the year. I have a "main menu" sheet why has each day hyperlinked. However, the Sheet is quite crowded and unappealing to the eye. I would like to change the main menu so that there is a cell for each month. I would then like it to work so that if I click on a month, a drop down menu(with or without a scroll bar) that allows me to select which daily sheet I would like to view(via a hyperlink). How do I create drop down list that include active hyperlinks?

Thanks

I have been working on something similiar to this, and for the longest time pulling out my hair trying to figure out a way to do it. However, just the other day I did. Here is what I did:

Not sure how much you know about drop down menu's, but within the format contrl box (where you selected the cells you wanted to display) there is another box that is refered to as cell link. You want to reference any blank cell, for example A1. When you select a month, a number will apear in that box (1 - the number of items in the list)

In a seperate sheet, you will want to list out all your hyperlinks, and to the left of them, put the number 1- ....

In the cell where you want your hyper link to be displayed, put in a formula that combines Vlookup, hyperlink and concatenate. It will look a bit like the one I used below. What is does is reference the reference number from the drop down menu cell (A1), does a lookup function on the sheet with all the hyperlinks, then takes the hyperlink from that cell and combines. You will probably need to modifiy a few things, but this is the general concept.

=IF(VLOOKUP('data drop down'!D3,'Specs file links'!A:B,2,FALSE)="","",HYPERLINK(CONCATENATE(VLOOKUP('data drop down'!D3,'Specs file links'!A:B,2,FALSE))))

I have been working on something similiar to this, and for the longest time pulling out my hair trying to figure out a way to do it. However, just the other day I did. Here is what I did:

Not sure how much you know about drop down menu's, but within the format contrl box (where you selected the cells you wanted to display) there is another box that is refered to as cell link. You want to reference any blank cell, for example A1. When you select a month, a number will apear in that box (1 - the number of items in the list)

In a seperate sheet, you will want to list out all your hyperlinks, and to the left of them, put the number 1- ....

In the cell where you want your hyper link to be displayed, put in a formula that combines Vlookup, hyperlink and concatenate. It will look a bit like the one I used below. What is does is reference the reference number from the drop down menu cell (A1), does a lookup function on the sheet with all the hyperlinks, then takes the hyperlink from that cell and combines. You will probably need to modifiy a few things, but this is the general concept.

[/HTML]=IF(VLOOKUP('data drop down'!D3,'Specs file links'!A:B,2,FALSE)="","",HYPERLINK(CONCATENATE(VLOOKUP('data drop down'!D3,'Specs file links'!A:B,2,FALSE))))[HTML]