Link Tab Name to Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sheet one of my workbook is database that subsequent worksheet draws info from.
The subsequent sheets are all same template with VLOOKUP / INDEX whos return
contingent on entry in one cell in the sheet.

I would like this one cell to equal the TAB or SHEET name.

Is this possible ?

Thanks for your trusted feedback,
Dallas
 
Thank you Kindly Ardus

Ardus Petus said:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

HTH
--
AP

SteveT said:
Sheet one of my workbook is database that subsequent worksheet draws info from.
The subsequent sheets are all same template with VLOOKUP / INDEX whos return
contingent on entry in one cell in the sheet.

I would like this one cell to equal the TAB or SHEET name.

Is this possible ?

Thanks for your trusted feedback,
Dallas
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Autopopulate cell name with tab name 4
Using names referencing a cell in another workbook 2
Copy tab name to a cell or opposite 1
tab name = cell value 7
How to get range names to Apply across multiple tabs 1
Linking two cells of text together 3
Excel lookup across entire workbook 1

Back
Top