Link Tab Name to Cell
 

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

Link Tab Name to Cell
 

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

HTH
--
AP

"SteveT" a écrit dans le message de
...
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

Link Tab Name to Cell
 

Thank you Kindly Ardus

"Ardus Petus" wrote:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

HTH
--
AP

"SteveT" a écrit dans le message de
...
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