I've noticed there are a number of answers to similar questions already but I'm struggling to get them to work so apologies for a potentially duplicate question.
I have a large spreadsheet with a wide range of training course data held in various sections. I would like to use a drop down list of the various course titles so that the user, when selecting a course title, is taken straight to the relevant section of the spreadsheet. The dropdown is currently located in AJ2 and sources from B51:B85 (including a blank at the top).
As an example, if they select Health & Safety Awareness, I need to jump to AG7. If selecting 'Equality and Diversity', I need to jump to H95 and so on for the remaining course titles. If nothing is selected, then the sheet continues to allow navigation as normal.
Any suggestions really welcome - thanks!
Bookmarks