Hi,
I want to combine two aspects of some table of contents macros. I have used the one available on the Office site:
Excel Blog - Add a table of contents to your workbook
Which works very well. However, I wanted to add a feature that someone wrote on MrExcel that prints the cell A1 on each sheet in the TOC.
Table of Contents | Excel Workbook | Macro to create a table of contents for a workbook
I want to have a column with the sheet names hyperlinked to each sheet, which the Office macro already does. I then want to have the cell A1 of each sheet put as a description in the B column on the TOC.
Eg.
Sheet Description
Jan(hyperlinked) Sales in January
Feb(hyperlinked) Sales in February
Mar(hyperlinked) Sales in March
Does that make sense?
Cheers!
I want to combine two aspects of some table of contents macros. I have used the one available on the Office site:
Excel Blog - Add a table of contents to your workbook
Which works very well. However, I wanted to add a feature that someone wrote on MrExcel that prints the cell A1 on each sheet in the TOC.
Table of Contents | Excel Workbook | Macro to create a table of contents for a workbook
I want to have a column with the sheet names hyperlinked to each sheet, which the Office macro already does. I then want to have the cell A1 of each sheet put as a description in the B column on the TOC.
Eg.
Sheet Description
Jan(hyperlinked) Sales in January
Feb(hyperlinked) Sales in February
Mar(hyperlinked) Sales in March
Does that make sense?
Cheers!
