how to create a custom auto fill sequence

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.