We are big fans of using Hyperlinks when navigating through large spreadsheets. One of the big problems is creating the hyperlinks. It is easy enough to create but very manual. As a result we recommend you look at this link to see some code that creates a reusable macro that you can run on a workbook.
Create a navigation list with Hyperlinks (VBA Code)
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the
Johannesburg or the MS Excel 3 Day Advanced Course Cape Town . If you prefer online learning or live outside South Africa, look at our MS Excel 3 Day Advanced training course . online MS Excel training courses
Did you know that there is a quick way to eliminate errors in you Excel spreadsheets?
See how to find and correct these error types with a
Spreadsheet Auditing Tool that will find:
Formulas that have been accidentally changed/ replaced,
Numbers that were added onto a formula and forgotten about,
Links to the wrong workbooks,
Changes between one version of a spreadsheet and another,
Which sheets cannot be deleted (and why),
The errors in Pivots, Charts, Conditional Formatting and more, and
Why your spreadsheet is so slow.
You can also see more on the free
Auditing an Excel spreadsheet course (link to the software is included in the course as well).