copy a pattern formula

[ramzangh]

i have 2 excel sheets. sheet one named "Entry" in which i have data in 6 sets of columns i.e (col C to col H ,col I to N, col O to T , col U to Z ,Col AA to AF and Col AG to AL). i want to shift this date to other sheet named "Result" in the following way.
at first row of "Result" first row of group one from sheet "Entry"
at row 2 of "Result" row 2 of group two from sheet "Entry"
at row 3 of "Result" row 3 of group three from sheet "Entry"
at row 4 of "Result" row 4 of group four from sheet "Entry"
at row 5 of "Result" row 5 of group five from sheet "Entry"
at row 6 of "Result" row 6 of group six from sheet "Entry"
after that a blank line and than repeating these pattern downward
when I copy and paste this group ,it takes the result from 7th row instead of row 2 of "Entry"
Any solution? Thanxs in advance

[p45cal]

in A1 of the Results sheet:
=OFFSET(Entry!$A$1,MOD(ROW()-1,6)+INT((ROW()-1)/6)+1,(MOD(ROW()-1,6)+1)*6+COLUMN()-5)
and copy across 6 cells and copy down as far as necessary.
It may need a little tweak because I assumed headers were present in the ENTRY sheet.
Finally, you can of course, copy/paste-special|values.