Hi All!
I have a huge and voluminous Excel file that I want to organize.
The file has about 7000 headings (which does not have the Heading style) and data within each of the heading.
I have to update this sheet very often so here is what I need:
- A TOC. Now, I understand Excel does not support TOCs but is it possible to have a TOC imported from Word, if I were to recreate all the data to the Word doc?
- A header with a StyleRef indicating the name of the Heading for the data on the respective page.
Thanks in advance.
Matt