Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got a template sheet containing "formulas as text" (I have just wiped away
the "=" and formated the cells as text) In another sheet I want to puzzel it together again as real formulas - I need to put an "=" and the "formulas as text" In the template sheet here called Sheet2: Sheet20.Range("A1:A2") A1: ShtX!$C$29-ShtY!$C$29 A2: ShtX!$C$30-ShtY!$C$30 In Sheet1, where I want to have the formulas visual and working. I want the result to be the products from the newborn formulas and the formulas visual just as an ordinary formula in a cell use to. Like if i would have written: A1: = ShtX!$C$29-ShtY!$C$29 A2: = ShtX!$C$30-ShtY!$C$30 Easy but complex to describe, maybe? instead of writing the formula, I want to create it from a "template" with the formula I'm sure this is easy to do, but I've tried several ways know without success. /Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i count Text in the Cells, but not formulas. | Excel Discussion (Misc queries) | |||
Construct address as a reference not "text" | Excel Worksheet Functions | |||
Construct cell reference for use in formula | Excel Worksheet Functions | |||
How do I convert cells containing formulas to text (value returned | Excel Worksheet Functions | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |