Is it possible to create a table of contents in excel using the headers of
sheets?

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



In article ,
"robin" wrote:

Is it possible to create a table of contents in excel using the headers of
sheets?