G
Guest
I currently have a workbook with many sheets sheets categorized by regions
and then specific locations within these regions. I am attempting to create
a table of contents which would provide easy/quick access to any specific
sheet within the workbook. I am currently using macro buttons in my table of
contents however, it seems too cumbersome to search through all the buttons
(many sheets). I would like to create a drop down combo box which would
advance directly to the specific sheet by selecting the location within the
drop down. I would appreciate any help/advise you could provide.
and then specific locations within these regions. I am attempting to create
a table of contents which would provide easy/quick access to any specific
sheet within the workbook. I am currently using macro buttons in my table of
contents however, it seems too cumbersome to search through all the buttons
(many sheets). I would like to create a drop down combo box which would
advance directly to the specific sheet by selecting the location within the
drop down. I would appreciate any help/advise you could provide.