Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box hyperlink navigation
I have worksheets each representing a weekly log. Within each worksheet is a
list of individuals with their log entry for that week. I want each individual to be able to navigate through the workbook using an Index worksheet. I can do it using a long list of hyperlinks for each week under each person's name like below: John Jane Jack 01-07 01-07 01-07 01-14 01-14 01-14 01-21 01-21 01-21 doing this for 52 weeks is not as user friendly as a drop down menu approach via a combobox. Is there a way to navigate using this approach? Or is there an even better way? Thanks, Kate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Navigation | Excel Worksheet Functions | |||
Navigation | Excel Discussion (Misc queries) | |||
Hyperlink Navigation | Excel Discussion (Misc queries) | |||
hyperlink in combo box/data validation | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) |