ExcelBanter - EXCEL Table of Contents

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - EXCEL Table of Contents (https://www.excelbanter.com/excel-worksheet-functions/8714-excel-table-contents.html)

robin

EXCEL Table of Contents

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

JE McGimpsey

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?

All times are GMT +1. The time now is 11:06 PM.