dbertenshaw
New Member
- Joined
- Apr 14, 2002
- Messages
- 1
I have developed and spreadsheet of quite complex calculation using numerical approximation, and would like to use it as a function. I want to be able to call its calculation by passing a value or values to certain cells, then get back the computed values. I would then use this in another worksheet in multiple cells to perform analysis of other data already in that sheet.
In an ideal world, from sheet2 I would be be able to
CALL(sheet1!A1B2=C2B2, S4E4=sheet1!D3F4) where sheet1 contained the function calculation.
Since I want to embed this call in many multiple cells in sheet2, then a macro doesnt seem to be the right thing.
Any ideas??
This message was edited by dbertenshaw on 2002-04-15 07:13
In an ideal world, from sheet2 I would be be able to
CALL(sheet1!A1B2=C2B2, S4E4=sheet1!D3F4) where sheet1 contained the function calculation.
Since I want to embed this call in many multiple cells in sheet2, then a macro doesnt seem to be the right thing.
Any ideas??
This message was edited by dbertenshaw on 2002-04-15 07:13