Worksheets automatic references

[Carlos Kochinski]

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

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

This formula is done manualy, but, if I itroduce a new
sheet in my file, I'd like to put a name in a celule and
get reference to the new sheet, 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

 

[jasonmorin]

=INDIRECT("'"&A1&"'!A2")*1,2%

HTH
Jason
Atlanta, GA

 

[AlfD]

Hi!

Try the INDIRECT worksheet function. This will let you put a sheet nam
in a cell and then put it in a formula.


Al