Something like Indirect

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?
 
J

J.E. McGimpsey

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")
 
Top