Setting output/input cells

Push/Pull: Define as output to row/input from row

In-Row Workbooks

Reading global variables

Define as input from global variables

ibidem

Referencing a named area from the overhead

Define as input from overhead. For better performance avoid large areas.

ibidem

Adding in-row workbook to database of articles

ibidem

Setting visible area for each sheet

In Edit mode, Home>Show>Set visible area

Range of Cells