indirect worksheet references

  • Thread starter Thread starter elias tauscher
  • Start date Start date
E

elias tauscher

I have created a workbook with several end of month worksheets.
I analyze data putting together in a different worksheet of the same
workbook data from different worksheets.
If I put in R1C1 the name of a worksheet and in R1C2 a different one,
how should I input the data as to reference different worksheets
changing the contents of those cells ?
It looks as I should use INDIRECT but I cannot get the right syntax.
Thank you
 
Something like this?

=INDIRECT("'"&R[-2]C[-2]&"'!R[-1]C[-2]",FALSE)

depending on where you put the formula, it is easier if you use the A1 type
of references

=INDIRECT("'"&A1&"'!A2")
 
Back
Top