Good morning/evening !
I would like to create a menu presented as a drop down list so that when I click on any of the choices, it refers to a cell in the same excel sheet. The original sheet I am working with is rather big with about 1000 lines (I cannot break it into smaller sheets because I need all the information inside that one sheet). There are titles for different sections so the menu is really to facilitate the navigation through the sheet. For example, there are 3 sections and I want to go to section 2, I click on the menu, select section 2 and it takes me to the title where section 2 is.
I have attached a sample of what my big file looks like.
Hopefully you can help me. I am not very good (if not at all) with vba so any help is very much welcomed.
Thank you for your time !
Bookmarks