Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BrianSch

  1. BrianSch

    Return the tab name of any cell.

    Yes, the link to the question is near the top just below my name. The original question was: Is there a way (via formula) to get the name from a sheet tab for use as a cell in another page? (Something like referencing a cell, with ='Sheet1'!A5) but to get the name off the sheet tab itself...
  2. BrianSch

    Return the tab name of any cell.

    thread68-1260610 This is in reference to a thread where a user was looking to return the tab name of a cell on another worksheet. I had the same question and came up with this formula, which should work in any worksheet or excel file...

Part and Inventory Search

Back
Top