In excel I have a workbook with multi tabs at the bottom, I want to make a sheet in the same workbook that would have a cell to link each tab to the front page. Kind of like an index page that would have a link to each tab..
In excel I have a workbook with multi tabs at the bottom, I want to make a sheet in the same workbook that would have a cell to link each tab to the front page. Kind of like an index page that would have a link to each tab..
CREATE A HYPERLINKED LIST OF SHEETS IN A WORKBOOK ON A FRONT SHEET
This macro creates a "table of contents" on a sheet at the beginning of the workbook. Each sheet listed is also an active Hyperlink so click the name will take you directly to the sheet. Put a link on all your other sheets back to this front sheet and you have an extremely fast navigation system for large workbooks. There's a sample file for you to see this operate.
Once the hyperlinks are created for you, you could reorganize them on that front sheet in any visual way you wish to make them easy to see all at once.
Creating links to every sheet tab in a index page may be a simple operation if you use an application Kutools for Excel. It is a Excel add-ons collection that can help avoid the repetitive operations in Excel. I don't mind using macro to create links, but when there is a tool available, why not choose and try it? Very easy to use and do help save much time.
Because it's not free. When you can do it yourself or get someone to help you do it yourself, why not do it yourself?Quote:
I don't mind using macro to create links, but when there is a tool available, why not choose and try it?
All times are GMT -7. The time now is 06:43 AM. |