Friday, 20 September 2013

Referencing a spreadsheet tab title in a cell


Problem:

Referencing a spreadsheet tab title in a cell

Solution:

a) First save the workbook.
b) Then paste the formula given below in a cell to get reference.

=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,31)

c) See the magic