formula for tab value

Guest · Nov 7, 2007

i want to show in a cell what is in the tab on the worksheet. please advise
how do i go about that.

Guest · Nov 7, 2007

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

Name a worksheet tab based on the value in a cell.	1	Apr 2, 2010
TABS formula Is This Possible & How	2	Feb 27, 2010
Array	3	Jun 8, 2011
Freeze Formulas - Replace Worksheet	5	Feb 18, 2010
Excel formula for an "if" "then" scenario linking 3 worksheets	2	Feb 23, 2010
Problem with 2007 saved as 2003	2	Oct 27, 2009
Blank Suppression	3	Jul 6, 2011
Help with this formula	3	Jul 25, 2012

Ask a Question