View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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..