how to create a custom auto fill sequence

**benishiryo** · 10-01-2012, 03:02 AM

hi lix333, welcome to the forum. try this formula in B1:
=INDIRECT("A"&FLOOR(ROW(A10)/10,1))

**lix333** · 10-01-2012, 12:37 PM

Originally Posted by benishiryo

hi lix333, welcome to the forum. try this formula in B1:
=INDIRECT("A"&FLOOR(ROW(A10)/10,1))

Wow!

1. Thank you for responding so fast.
2. Thanks for the formula. I think this is exactly what i have been looking for!

Many many thanks. This just saved me days of work.

**lix333** · 10-04-2012, 08:26 PM

Originally Posted by benishiryo

hi lix333, welcome to the forum. try this formula in B1:
=INDIRECT("A"&FLOOR(ROW(A10)/10,1))

Well, I thought I was done but my spreadsheet became a bit more complex.

Is there a way to also go horizontally to the next column? so B1 to B10 = A1 and then C1 to C10 = A2 and then d1 to d10 = A3 then highlight A1 to A3 and drag to custom auto fill downward so that b11 to b20 = A4 and then C11 to C20 = A5 and then D11 to D20 = A6 so on and so on.

If this is possible then thanks in advance!