Skip to content
EXAMPLE

Dynamically Sized Report Between Workbooks

Summary

Publish a table whose row count changes, receive it in another workbook, and keep the receiving range synchronized as the report grows or shrinks.

Files Used in This Example

Prerequisites

  • Two workbooks connected to the same Runline environment.
  • A clear receiving area large enough for the report's expected maximum size.

Step 1: Publish only populated rows

Trim trailing blank rows before publishing so the report contracts when source rows are removed.

=U.PUBLISH(M4,M5,U.SUBRANGE(L8:N25))

Step 2: Subscribe from the receiving workbook

Use the same report group and report name as the publisher.

=U.SUBSCRIBE(C3,C4)

Step 3: Render a changing footprint

Pad the subscribed report so the displayed array expands and contracts, clearing values that no longer belong to the report.

=U.PAD(C5,TRUE)

Step 4: Extend adjacent calculations deliberately

If calculated columns must follow the changing report, copy their formulas through a reserved range instead of placing unrelated data beside the spill area.

=U.COPY_PASTE(IF(B9="","",IFERROR(C9*D9,"")),B10:D15,"down,all")

Result

Adding or removing source rows changes both the published report and the receiver's displayed footprint without leaving stale report rows behind.

What’s Happening

What’s happening here?

U.SUBRANGE removes trailing blanks at the source; U.PAD owns the changing footprint at the destination. The publisher and receiver therefore agree on both report identity and current shape.