Results 1 to 15 of 15

Display a list of sheet names like a contents page.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-12-2012
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    104

    Smile Display a list of sheet names like a contents page.

    Hi all,

    I would like to be able to display all of the sheets in a workbook as a list on the front sheet.

    I have a front "Contents" Sheet (attached at the bottom of my post)


    In the "Ticket No." column I wanted to have the sheet name, in the "Date" and "Description" column I wanted to display cell values from each sheet; which would be the date and description of that sheet/"Ticket". The "Resolved?" column I will be able to do after I have this part figured out.

    I would be very grateful if anyone could help me with this, it's been driving me nuts! :P

    EDIT: The workbook is also attached to this post.

    Thanks,
    Storm
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Storm08; 06-05-2014 at 10:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split contents of cell into single names then search for names on different sheet.
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 12-18-2013, 10:53 AM
  2. [SOLVED] Simple macro to create list of sheet names and the contents of cells A1 & N1 of each sheet
    By atcsmh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2013, 11:11 AM
  3. Yes/no drop down list needs to populate a contents page with matching page numbers
    By limebaish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2013, 02:46 PM
  4. [SOLVED] Excel 2007 : Display All worksheet names on a page
    By Justinetme in forum Excel General
    Replies: 3
    Last Post: 04-25-2012, 04:35 PM
  5. How do I display list of tab names used in a workbook on a sheet
    By tmottur in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2005, 05:45 PM

Tags for this Thread

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