Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Navigating within worksheet
I have a spreadsheet around 6000 rows long. I want to include a means of
navigating around the spreadsheet in a freeze framed section at the top. I have considered a number of options including a simple drop down list (via the validaton command) and a goto button in VBA or the use of a dropdown list and hyperlinks. While this works reasonably well there are arond 100 locations I wish to navigate to and including these in a single drop-down list is not practical - I really want to be able to have some sort of drop down list which displays 10 high level categories, then within each of these categories a further 10 sub categories, much like standard office menus. Does anyone have any useful pointers or VBA to help me achieve this cheers Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |