In Excel , table of contents can be automatically created a with a macro. This macro creates a new sheet named "Workbook_Index" as first sheet of workbook. The macro then lists in this sheet the names of all the sheets in the workbook and inserts a hyperlink for each one.User can be returned to index sheet when the "Esc" key is pressed while on any sheet. Read more and download sample file here : Excel table of contents
In Excel , table of contents can be automatically created a with a macro.
This macro creates a new sheet named "Workbook_Index" as first sheet of workbook. The macro then lists in this sheet the names of all the sheets in the workbook and inserts a hyperlink for each one.User can be returned to index sheet when the "Esc" key is pressed while on any sheet.
Read more and download sample file here : Excel table of contents