software

I've looked around here and found this formula for making the sheet name
appear in a cell:
=MID(CELL(quot;Filenamequot;,A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,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?

In cell A22 on the Summary sheet, use the following formula:

=MID(CELL(quot;Filenamequot;,FormulaSheet1!A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,FormulaSheet1!A1)) 1,255)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Olle Svenssonquot; gt; wrote in
message
news
gt; It is saved. That is not the matter. See, I want to make the
gt; filename of
gt; FormulaSheet1 show up in cell A22 on the Summary sheet. Exactly
gt; how do I do
gt; that? Just reading the formula does not help me at all.
gt;
gt; quot;paulquot; wrote:
gt;
gt;gt; what do you mean it doesnt work?The file MUST be saved before
gt;gt; you will see
gt;gt; anything in the cell....You will prolly need to use the
gt;gt; indirect function to
gt;gt; get a shheet reference from your formula....the last part your
gt;gt; question will
gt;gt; require a macro
gt;gt; --
gt;gt; paul
gt;gt; remove nospam for email addy!
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Olle Svenssonquot; wrote:
gt;gt;
gt;gt; gt; I've looked around here and found this formula for making
gt;gt; gt; the sheet name
gt;gt; gt; appear in a cell:
gt;gt; gt; =MID(CELL(quot;Filenamequot;,A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,A1)) 1,255)
gt;gt; gt;
gt;gt; gt; I can not get it to work. At all. I want to use it to link
gt;gt; gt; sheets to a
gt;gt; gt; summary sheet. If anyone could give me a step-by-step, that
gt;gt; gt; would be great.
gt;gt; gt; Thanks.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; P.S. What I really want to do is to make a template where
gt;gt; gt; every time I copy
gt;gt; gt; one of the template sheets, the new one ends up with sheet
gt;gt; gt; name in the
gt;gt; gt; Summary sheet as well as links to different cells in the new
gt;gt; gt; sheet. Is it
gt;gt; gt; possible to do?
Thanks, but it still does not work. I get the quot;The formula you typed contains
an errorquot; message.

quot;Chip Pearsonquot; wrote:

gt; In cell A22 on the Summary sheet, use the following formula:
gt;
gt; =MID(CELL(quot;Filenamequot;,FormulaSheet1!A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,FormulaSheet1!A1)) 1,255)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;Olle Svenssonquot; gt; wrote in
gt; message
gt; news
gt; gt; It is saved. That is not the matter. See, I want to make the
gt; gt; filename of
gt; gt; FormulaSheet1 show up in cell A22 on the Summary sheet. Exactly
gt; gt; how do I do
gt; gt; that? Just reading the formula does not help me at all.
gt; gt;
gt; gt; quot;paulquot; wrote:
gt; gt;
gt; gt;gt; what do you mean it doesnt work?The file MUST be saved before
gt; gt;gt; you will see
gt; gt;gt; anything in the cell....You will prolly need to use the
gt; gt;gt; indirect function to
gt; gt;gt; get a shheet reference from your formula....the last part your
gt; gt;gt; question will
gt; gt;gt; require a macro
gt; gt;gt; --
gt; gt;gt; paul
gt; gt;gt; remove nospam for email addy!
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Olle Svenssonquot; wrote:
gt; gt;gt;
gt; gt;gt; gt; I've looked around here and found this formula for making
gt; gt;gt; gt; the sheet name
gt; gt;gt; gt; appear in a cell:
gt; gt;gt; gt; =MID(CELL(quot;Filenamequot;,A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,A1)) 1,255)
gt; gt;gt; gt;
gt; gt;gt; gt; I can not get it to work. At all. I want to use it to link
gt; gt;gt; gt; sheets to a
gt; gt;gt; gt; summary sheet. If anyone could give me a step-by-step, that
gt; gt;gt; gt; would be great.
gt; gt;gt; gt; Thanks.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; P.S. What I really want to do is to make a template where
gt; gt;gt; gt; every time I copy
gt; gt;gt; gt; one of the template sheets, the new one ends up with sheet
gt; gt;gt; gt; name in the
gt; gt;gt; gt; Summary sheet as well as links to different cells in the new
gt; gt;gt; gt; sheet. Is it
gt; gt;gt; gt; possible to do?
gt;
gt;
gt;