Hi All

Using the formula (excel 2007) below (thanks Max) I'm trying to duplicate
the contents of cell A12 (row 1 of my data) into the cells below it for the
number of rows corresponding to the value found in F2.

For instance F2 = 9 then once I enter any number into A12 I want that to
copy down another 8 rows.

The problem is that it copies one extra than I need. (because the formula
says to)

=IF(ROWS($1:1)$F$2,"",$A$12+ROWS($1:1)*0)

Adjustment appreciated. Thanks.