Is it possible to create a table of contents in excel using the headers of sheets?
R robin Jan 5, 2005 #1 Is it possible to create a table of contents in excel using the headers of sheets?
J JE McGimpsey Jan 5, 2005 #2 This macro on David McRitchie's site uses the sheet names, rather than the headers, but it should be relatively easy to adapt. Post back if you need assistance: http://www.mvps.org/dmcritchie/excel/buildtoc.htm
This macro on David McRitchie's site uses the sheet names, rather than the headers, but it should be relatively easy to adapt. Post back if you need assistance: http://www.mvps.org/dmcritchie/excel/buildtoc.htm
