| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is my cell displaying the formula ? | Excel Worksheet Functions | |||
| Formula result not displaying on worksheet | Excel Worksheet Functions | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
| Displaying worksheet name in cell | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Linear Mode
