| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatentate a formula with a variable sheet name.
Hi,
I am trying to change the link in worksheet formulas that are copied from one sheet to another by creating the formulas with the sheet name as a variable. In "sheet2" is the formula: ="="&"'"&J1&"'"&"!"&"a1+10" Cell J1 is the name of another sheet (i.e. Sheet1) The formula results in: ='Sheet1'!a1+10 The results are as I expected, however it is text and not a formula. How do I get the results to act as a formula. Don Pistulka |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatentate a formula with a variable sheet name.
Don,
Does this do it =INDIRECT("'"&J1&"'!a1")+10 -- HTH Bob Phillips "Don Pistulka" wrote in message ... Hi, I am trying to change the link in worksheet formulas that are copied from one sheet to another by creating the formulas with the sheet name as a variable. In "sheet2" is the formula: ="="&"'"&J1&"'"&"!"&"a1+10" Cell J1 is the name of another sheet (i.e. Sheet1) The formula results in: ='Sheet1'!a1+10 The results are as I expected, however it is text and not a formula. How do I get the results to act as a formula. Don Pistulka |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatentate a formula with a variable sheet name.
Bob,
That's It. Thanks Don Pistulka "Bob Phillips" wrote in message ... Don, Does this do it =INDIRECT("'"&J1&"'!a1")+10 -- HTH Bob Phillips "Don Pistulka" wrote in message ... Hi, I am trying to change the link in worksheet formulas that are copied from one sheet to another by creating the formulas with the sheet name as a variable. In "sheet2" is the formula: ="="&"'"&J1&"'"&"!"&"a1+10" Cell J1 is the name of another sheet (i.e. Sheet1) The formula results in: ='Sheet1'!a1+10 The results are as I expected, however it is text and not a formula. How do I get the results to act as a formula. Don Pistulka |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Concatentate in Formula | Excel Discussion (Misc queries) | |||
| Variable sheet and Formula Sheet | Excel Discussion (Misc queries) | |||
| Concatentate Join Identifier | Excel Worksheet Functions | |||
| Variable Sheet Name in Formula | Excel Discussion (Misc queries) | |||
| LookUp and Concatentate | Excel Worksheet Functions | |||
Linear Mode
