Something like Indirect

  • Thread starter Thread starter JAMES SYLVESTERSR
  • Start date Start date
J

JAMES SYLVESTERSR

Indirect can only be used from within the same worksheet.

I want to reference cells on another worksheet. I have tried $ but the
reference changes when the cells on the source worksheet are moved.

Is there any way to reference cells on another worksheet which would work
like indirect?
 
You can use INDIRECT() across worksheets:

On sheet 1:

A1: =INDIRECT("Sheet2!J1")

will return the value in sheet2, cell J1.

You could also name the range on the second sheet (say "myRng"), and
use

=INDIRECT("myRng")
 
Back
Top