Copy formula down column for a given number of rows

**dgo** · 06-23-2010, 11:26 AM

Hi,

I have a spreadsheet that has a formula in for example cell A2. Above this in cell A1 is a number, so for example 170.

I would like to be able to copy the formula in cell A2 for the given number in cell A1, so in this case 170 rows.

This will then be used on a various columns with different numbers in say B1, C1 etc.

Any help would be gratefully received.

Thanks,
Dominic.

**snb** · 06-23-2010, 11:34 AM

cells(2,1).resize([A1]).formula=[A1].formula

**NBVC** · 06-23-2010, 11:36 AM

A formula way to do that would be to alter you current formula in A2 to include a check on what row it is on as compared to the number in A1

e.g.

=IF(ROWS(A$1:A2)>A$1,"",4+5)

replace 4+5 with your actual formula (without the = sign in front).

Then copy down as far as you want....

You can then copy across multiple columns.

In the end, if this proves inefficient and resource intensive, you may be better with someone helping you create a macro.... but figured this would be an easy alternative.