copying data from one sheet to another and skipping 9 cells in destination sheet

[maersktanjong]

hi
i am trying to copy values from sheet to another.
in the data sheet i gave numbers from F5, F6 and so on. and in the destination sheet need the data in M24, M34, M44 and so on.
i was doing it by =F5 in M24, but i have 700 values to be copied every day and it wll take a long time.
if any formula to copy data every 10th cells in destination sheet.
thanks

 

[bebo021999]

M24:

=IF(MOD(ROWS($1:1)-1,10)=0,INDEX(Sheet1!$F$5:$F$100000,INT((ROWS($1:1)-1)/10)+1),"")

 

[maersktanjong]

M24:

=IF(MOD(ROWS($1:1)-1,10)=0,INDEX(Sheet1!$F$5:$F$100000,INT((ROWS($1:1)-1)/10)+1),"")

hi...it worked...thanks a lot...much appreciated