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:
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