Hi,

I need help creating a dynamic print area.

Sheet 1 is for calculations. Sheet 2 is for print, and uses IF formulas to pick up cell values from sheet 1.

Sheet 2 has 6 columns.
Rows 1 - 50 is always the first page and is without any tables. This page should always be included.
Rows 51 - 53 includes some information, and row 54 is the table header. These rows should always be included.
Rows A55:A1000, B55:B1000, C55:C1000, D55:D1000, E55:E1000 and F55:F1000 has IF formulas, and will pick up anywhere from 1 - 1000 rows from sheet 1.

I've tried out the OFFSET formula, but it seems to pick up my formulas as cell values and sets A55:F1000 as print area - even when it picks up only 1 or 2 rows from sheet 1.

Thanks in advance!