Displaying Worksheet name in cell using formula
 

I am trying to figure out a way to display the worksheet name of worksheet
"B" in worksheet "A" using a formla. Any suggestions?

Displaying Worksheet name in cell using formula
 

See


http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
CEG_Staffer wrote:

I am trying to figure out a way to display the worksheet name of worksheet
"B" in worksheet "A" using a formla. Any suggestions?

Displaying Worksheet name in cell using formula
 

How can you display the name of sheet "6" (for example) in a cell in sheet "1"?

"JE McGimpsey" wrote:

See


http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
CEG_Staffer wrote:

I am trying to figure out a way to display the worksheet name of worksheet
"B" in worksheet "A" using a formla. Any suggestions?

Displaying Worksheet name in cell using formula
 

Put the formula in sheet 6 then
link to it. Just copy the cell with the formula, go to
sheet 1 and do editpaste special and select paste link

--


Regards,


Peo Sjoblom

"CEG_Staffer" wrote in message
...
How can you display the name of sheet "6" (for example) in a cell in sheet
"1"?

"JE McGimpsey" wrote:

See


http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
CEG_Staffer wrote:

I am trying to figure out a way to display the worksheet name of
worksheet
"B" in worksheet "A" using a formla. Any suggestions?

Displaying Worksheet name in cell using formula
 

I am trying to avoid a lot of linking. This file is rather complex and has
over 30 sheets. Any suggestions?

"Peo Sjoblom" wrote:

Put the formula in sheet 6 then
link to it. Just copy the cell with the formula, go to
sheet 1 and do editpaste special and select paste link

--


Regards,


Peo Sjoblom

"CEG_Staffer" wrote in message
...
How can you display the name of sheet "6" (for example) in a cell in sheet
"1"?

"JE McGimpsey" wrote:

See


http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
CEG_Staffer wrote:

I am trying to figure out a way to display the worksheet name of
worksheet
"B" in worksheet "A" using a formla. Any suggestions?