LindsayLindsayExcel
New Member
- Joined
- Apr 25, 2014
- Messages
- 1
Hi,
I'm working on a workbook that contains multiple worksheets, each with a few different tables. I've created a table of contents for the file that is linked to each of the table titles (all named Table 1, Table 2, etc). Typically, I hyperlink the table names to their respective cells manually, but because there are many so many tables, I'd like to find a way to speed up the process. I found one macro that creates a TOC based on the worksheet name and hyperlinks to the first row in each worksheet, but was wondering if anyone knows of a macro that would link to the the individual cells that contain the table titles. Questions and suggestions appreciated!
Thanks for reading!
I'm working on a workbook that contains multiple worksheets, each with a few different tables. I've created a table of contents for the file that is linked to each of the table titles (all named Table 1, Table 2, etc). Typically, I hyperlink the table names to their respective cells manually, but because there are many so many tables, I'd like to find a way to speed up the process. I found one macro that creates a TOC based on the worksheet name and hyperlinks to the first row in each worksheet, but was wondering if anyone knows of a macro that would link to the the individual cells that contain the table titles. Questions and suggestions appreciated!
Thanks for reading!