Link Tab Name to Cell

S

SteveT

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
 
S

SteveT

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...
 
Top