Help - Repeat formulas

  • Thread starter Thread starter Sherry
  • Start date Start date
S

Sherry

hi,

this is what i want to do.

b1 =sheet1!a1
then when i drag down i get
b2=sheet1!a2
..
..
..
and so on..

i want
b1 to b50 to be sheet1!a1
b51 to b100 to be sheet1!a2
....
...
....
b9950 to b10000 to be sheet1!a200

is there an easy way to do this. I tried changing bx=a$x to the next value
manually after every 50 rows. But i have about 10000 and its really not
worth the effort.

SOS!
Sherry
 
thanks frank.

but this is not what i wanted. till the 50th row the formula should remain
unchanged.
i.e. ='sheet1'!A1
starting the 51st row the formula should become:
='sheet1'!A2

in other words, the formula should iterate 50 times before changing.

~ sherry
 
Hi Sherry
sorry, not carefully in my reading. Use the following in B1
=OFFSET('sheet1'!$A$1,INT((ROW()-1)/50),0)
and copy down
 
Back
Top