Sheetname in Defined name ...???

[SIGE_GOEVAERTS]

Hello There,

I would like to deduct 2 sheets ... like:
in Comparison!A1: =Sheet2!A1-Sheet1!A1

Though this is a "Static" solution!

If I have several sheets, I would like to be able to write the name of
my 2 sheets-to-be-compared in a Name (variable)...

So that I can make the deduction between the sheets of which the names
are in the Defined Name (or Cell)

Something like:

in Comparison!A1: ="'"&B3&"'"&"!A1"&"-"&"'"&B4&"'"&"!A1"

with in B3: Sheet2
& in B4: Sheet1

Obviously it does not work ...
I hope you can understand what I mean, and provide me an intelligent
hack!!!

) Sige

 

[SIGE_GOEVAERTS]

INDIRECT the solution


=INDIRECT($A$6&"!"&ADDRESS(ROW();COLUMN();4;TRUE))-INDIRECT($A$7&"!"&ADDRESS(ROW();COLUMN();4;TRUE))

)