View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JFREE223 JFREE223 is offline
external usenet poster
 
Posts: 10
Default Create Table of Contents based on Heading style - not naming a ran

Is it possible to create a table of contents to pull from many worksheets
based on the heading style used in a cell? The name range/hyperlink
functionality is too time consuming for the amount of data being used.