Repeat a cell value for a set number of rows

[rockb78]

Hi

I am trying to program excel to take a value from a single row/column (a1) and repeat it in an equation in another row/column (say b1 to b10) for a set number of rows. After this number of rows is met, I would like to take the value from row following (a2) and add it to the range b11 to b20.

Is there a simple command that does this?

[tigeravatar]

rockb78,

Give this a try:
=INDIRECT("A"&INT((ROW()-1)/10)+1)