Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2001
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab Names (Excel 2000)

    Is there a way to capture the tab name of a sheet (i.e., SHEET1), within a cell on a spreadsheet? We have formula's linked to various sheets within a workbook, and I would like to use the Sheet Names as the headers in a consolidation sheet within the same workbook. Any ideas?

    Linda

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Tab Names (Excel 2000)

    this:
    <pre>=MID(CELL("filename",A2),FIND("]",CELL("filename",A1))+1,31)</pre>

    will give the name of the sheet containing the formula

    The sheet name can be directly added in a custom header.
    Steve

Posting Permissions

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