Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet name to cell.
I've looked around here and found this formula for making the sheet name
appear in a cell: =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) I can not get it to work. At all. I want to use it to link sheets to a summary sheet. If anyone could give me a step-by-step, that would be great. Thanks. P.S. What I really want to do is to make a template where every time I copy one of the template sheets, the new one ends up with sheet name in the Summary sheet as well as links to different cells in the new sheet. Is it possible to do? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text from one sheet cell to appear in another sheet cell | Excel Worksheet Functions | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |