Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Skeep
 
Posts: n/a
Default 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

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Skeep
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to add cell comments in unlocked cell on protected worksheet dan400man Excel Discussion (Misc queries) 3 December 16th 05 08:02 PM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
How can I link a cell in one worksheet to a cell in another works. EWI_Guy Excel Worksheet Functions 3 April 5th 05 09:15 PM
Refrencing another cell in a worksheet that "could" exist KimberlyC Excel Worksheet Functions 1 February 7th 05 07:09 PM


All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"