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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet name to cell.
In cell A22 on the Summary sheet, use the following formula:
=MID(CELL("Filename",FormulaSheet1!A1),FIND("]",CELL("Filename",FormulaSheet1!A1))+1,255) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Olle Svensson" wrote in message ... It is saved. That is not the matter. See, I want to make the filename of FormulaSheet1 show up in cell A22 on the Summary sheet. Exactly how do I do that? Just reading the formula does not help me at all. "paul" wrote: what do you mean it doesnt work?The file MUST be saved before you will see anything in the cell....You will prolly need to use the indirect function to get a shheet reference from your formula....the last part your question will require a macro -- paul remove nospam for email addy! "Olle Svensson" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet name to cell.
Thanks, but it still does not work. I get the "The formula you typed contains
an error" message. "Chip Pearson" wrote: In cell A22 on the Summary sheet, use the following formula: =MID(CELL("Filename",FormulaSheet1!A1),FIND("]",CELL("Filename",FormulaSheet1!A1))+1,255) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Olle Svensson" wrote in message ... It is saved. That is not the matter. See, I want to make the filename of FormulaSheet1 show up in cell A22 on the Summary sheet. Exactly how do I do that? Just reading the formula does not help me at all. "paul" wrote: what do you mean it doesnt work?The file MUST be saved before you will see anything in the cell....You will prolly need to use the indirect function to get a shheet reference from your formula....the last part your question will require a macro -- paul remove nospam for email addy! "Olle Svensson" wrote: 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? |
Reply |
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 |