Hi, I am looking for a solution to have a drop down menu that selects a certain sheet within my spreadsheet. Please bare with me as my knowledge of Excel is fairly basic.
I have designed a spreadsheet to document the monthly checks of the work vans at the request of the boss.
I'm currently using click buttons to link to the relevant sheet. Here is the current setup of it:
\1
These are the macros being used:
Sub Menu()
Sheets("Menu").Select
End Sub
Sub BlankForms()
Sheets("Blank Forms").Select
End Sub
Sub June2016()
Sheets("Jun16").Select
End Sub
Sub July2016()
Sheets("Jul16").Select
End Sub
Sub August2016()
Sheets("Aug16").Select
End Sub
Sub September2016()
Sheets("Sept16").Select
End Sub
Sub October2016()
Sheets("Oct16").Select
End Sub
Sub November2016()
Sheets("Nov16").Select
End Sub
Sub December2016()
Sheets("Dec16").Select
End Sub
Sub January2017()
Sheets("Jan17").Select
End Sub
Sub February2017()
Sheets("Feb17").Select
End Sub
Sub SaveWorkBook()
ActiveWorkbook.Save
End Sub
Sub ExitExcel()
Application.Quit
End Sub
Instead I'm looking for a drop down menu so that I have one per year e.g. 2016, 2017 etc then when I click on that it it gives the months so that when I click on it it takes me to the relevant sheet.
It would be great if it automatically added any new sheets I created.
I'm using windows 7 and Excel 2007 if it makes a difference.
Any help is greatly appreciated Thanks.
Bookmarks