| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how do I make a cell equals the sheet name?
My worksheet name is BU300, I want the value of a specific cell, in the same
worksheet, to be BU300, without me having to type it. Is there a formula to do it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, how do I make a cell equals the sheet name?
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)
"Dallas, TX" wrote: My worksheet name is BU300, I want the value of a specific cell, in the same worksheet, to be BU300, without me having to type it. Is there a formula to do it? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, how do I make a cell equals the sheet name?
That will return the name of the sheet that was last active, you need to add
a cell reference (any cell will do) =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) also the workbook needs to be saved at least one time for it to work -- Regards, Peo Sjoblom "N Harkawat" wrote in message ... =MID(CELL("filename"),FIND("]",CELL("filename"))+1,99) "Dallas, TX" wrote: My worksheet name is BU300, I want the value of a specific cell, in the same worksheet, to be BU300, without me having to type it. Is there a formula to do it? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, how do I make a cell equals the sheet name?
Actually without a cell reference it returns the name of the last sheet
calculated -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... That will return the name of the sheet that was last active, you need to add a cell reference (any cell will do) =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) also the workbook needs to be saved at least one time for it to work -- Regards, Peo Sjoblom "N Harkawat" wrote in message ... =MID(CELL("filename"),FIND("]",CELL("filename"))+1,99) "Dallas, TX" wrote: My worksheet name is BU300, I want the value of a specific cell, in the same worksheet, to be BU300, without me having to type it. Is there a formula to do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
| Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Hybrid Mode
