Reusing formula
I get your point and agree. Sorry - no solution - but, hey, my problem is
solved so I'm back to work
Thanks for your contribution.
"Mark K." wrote:
Yes, I can use the name anywhere, but the formula always refers back to
the original sheet where the name was defined. So, with C1 selected on
sheet1, I define a name (say "test") and enter =A1*B1. If I enter =test
into a cell anywhere, the relative cells on sheet1 are used, no matter
what sheet I'm on.
In fact, the formula is automatically changed to =Sheet1!A1*Sheet1!B1 .
I would like it not to do that if at all possible.
TIA
|