How to put a worksheet tab name in a cell?
 

Does anyone know how to put a reference link or formula in a cell that
has the worksheet tab names on it. The following is what I am trying to
do:

work sheet 1 Total for all regions

cell a1 - name of worksheet 2 or the first region
cell b1 - name of worksheet 3 or the second region on so on

Please help..


--
Skeep
------------------------------------------------------------------------
Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822
View this thread: http://www.excelforum.com/showthread...hreadid=504865

How to put a worksheet tab name in a cell?
 

See

http://mcgimpsey.com/excel/formulae/cell_function.html

In article ,
Skeep wrote:

Does anyone know how to put a reference link or formula in a cell that
has the worksheet tab names on it. The following is what I am trying to
do:

work sheet 1 Total for all regions

cell a1 - name of worksheet 2 or the first region
cell b1 - name of worksheet 3 or the second region on so on

Please help..

How to put a worksheet tab name in a cell?
 

Thanks so much


--
Skeep
------------------------------------------------------------------------
Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822
View this thread: http://www.excelforum.com/showthread...hreadid=504865