how can i sepreate my excel sheet in one by one

[himanshu sharma]

Sir, I have a excel book approx 2 lakh above data in this sheet i have a problem i want to seprate my data row by row so i use copy and paste but this is very long task for me any soultion for convert this task in simple way check sheet 1 that is data and i put data in sheet 2 by copy paste one by one.

 

[bosco_yip]

Try,

In "Sheet 2" A4, formula copy across to G4 and all copy down :

=OFFSET(Sheet1!$A$1,(ROWS($1:1)*6+COLUMNS($A:A)+ROWS($1:1)-1)-7,)&""

Regards
Bosco