Quote:
Originally Posted by xor
Maybe like this:
|
Yes. It turns into relative referencing. Thanks.
But technicially speaking, I'm wondering if the blue highlighted one (below) could be all in one formula (so that there is only one cell).
Of course, the red one (my testing) returns an error (i.e. #REF!).
Code:
=INDIRECT("'"&B$1&"'!"&ADDRESS(ROW(),???))
=INDIRECT("'"&B$1&"'!"&ADDRESS(ROW()+1,COLUMN(INDIRECT("'"&B$1&"'!"&N$1)))