The data generation functions can reference other cells and sheets, in exactly the same way as standard Excel functions.

This is useful for creating variable data and interdependencies within and across sheets, and also allows data to be edited quickly and consistently across sheets.

To reference another cell or range of cells, enter the name of the cell or cell range at the relevant point in the formula.

The cell name or range can be typed manually, for example "A3" or "A3:15" for rows 3-15 in the A column. Alternatively, the name or range can be selected at the appropriate place in the formula, by clicking the cell or highlighting the cell range to be incorporated in the formula.