I have a spreadsheet with multiple sheets. On one sheet, call it sheet1, I have categories in ColA in alphabetical order, each of which have any number of data lines using ColA-Q. New categories are occasionally added, in alpha order.
Currently to find a category one has to scroll down the sheet.
I would like to have something like a category drop down list at the top that a user can select from and jump to that section of the sheet. I've used drop downs, hyperlinks, and range names in other places, but am stumped for a solution in this application. (It would have simple years ago when I worked in databases... .)
Any suggestions?
Alex
Currently to find a category one has to scroll down the sheet.
I would like to have something like a category drop down list at the top that a user can select from and jump to that section of the sheet. I've used drop downs, hyperlinks, and range names in other places, but am stumped for a solution in this application. (It would have simple years ago when I worked in databases... .)
Any suggestions?
Alex