Display Dynamic Range

T

Turin

I created a dynamic named range(Daily_Postage) from data on
sheet1(Import_Postage) that basically includes only the rows that have
data. Works good. Now I want to display that new set of data on
sheet2 without spreading formulas around in each cell. Thought I could
=OFFSET(Daily_Postage_Range,0,0,COUNTIF('Import_Postage!$A$A,">0",12)
in A1 and see the whole array on sheet2 but no.
Help?
Tim
 
B

Biff

Hi!

It doesn't work like that!

You'd have to select an array of cells equal to:

COUNTIF('Import_Postage!$A$A,">0",12

Then enter the formula as an array.

Biff
 
B

Biff

BTW, your formula is incorrect:
=OFFSET(Daily_Postage_Range,0,0,COUNTIF('Import_Postage'!$A$A,">0",12)
Click to expand...

Probably should be:

=OFFSET(Daily_Postage_Range,0,0,COUNTIF('Import_Postage'!$A:$A,">0"),12)

COUNTIF('Import_Postage'!$A:$A,">0") is the height argument

12 is the width argument

Biff
 
T

Turin

OK great. Getting there.
I still don't know how to DISPLAY the result without copying the
formula into each cell. The Daily_Postage array changes every day.
Daily Postage is 12 x 500 array of cells each with a formula or
reference in it. The days records show up across the 12 columns and
down as far as there's data, below that the formulas generate "" blank
cells. I want to copy the array of data only over to sheet 2.
 
Top