+ Reply to Thread
Results 1 to 2 of 2

Creating a Table of Content in Excel

Hybrid View

Guest Creating a Table of Content... 02-14-2005, 11:06 AM
Guest Re: Creating a Table of... 02-14-2005, 09:06 PM
  1. #1
    Michiel Junge
    Guest

    Creating a Table of Content in Excel

    Hello,

    I would like to create a dynamic table of content in excel, is this possible?

    thanks for your support

  2. #2
    Dave Peterson
    Guest

    Re: Creating a Table of Content in Excel

    Depends on what you mean...

    If you meant you want a worksheet that serves as a table of contents to the
    other sheets, David McRitchie has some code you may like that builds hyperlinks
    to cell A1 of those other sheets.

    In fact, you could see how David set up the hyperlinks and use that for your
    table of contents.

    http://www.mvps.org/dmcritchie/excel/buildtoc.htm


    But I'm not sure what dynamic means. If you want to build a hyperlink that
    points at a certain cell--no matter where you move it, try giving that cell a
    nice name (insert|name|define), then use that in the hyperlink.



    Michiel Junge wrote:
    >
    > Hello,
    >
    > I would like to create a dynamic table of content in excel, is this possible?
    >
    > thanks for your support


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1