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