Sheet reference

Refer to cells in the other table using the following notation.

CODE

<Sheet number>!<R1><C1>:<R2><C2>

<Sheet number> ← sequential number from the top table which starts from 1

<Rx> ← row number which starts from 1

<Cx> ← column string which starts from A

The upper left corner of the header is A1.

Ref. Sheet reference (Classic)