Worksheets automatic references

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Carlos Kochinski (carloskochinski_at_yahoo.com)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 14:15:42 -0700

I need a way to automatize the change of a work*** name
in a formule, for exemple:

=Sheet1!A2*1,2% (formule 1)

This formula is done manualy, but, if I itroduce a new
*** in my file, I'd like to put a name in a celule and
get reference to the new ***, for example:

The name "Sheet10" is taped in the celule A1, the celule
for reference.
In the celule B3 I have the formule 1, and I want that the
formule is changed to "=Sheet10!A2*1,2%" automaticaly.
Is it possible? Can I do it without a macro?

Thanks,
CHK
 

Quantcast