Greetings to all
I have data in sheet1.range("A8:S" & Last row)
I need simply an effective way to transfer data from sheet1 to sheet2
The transfer process would start in A8
each 20 rows would be transferred then left the next 7 rows
Blue cells as they are ... note that Blue cells in original file would contain formulas
the same with the rest of data
I have attached the expected results
If possible I need to avoid loops as original data is too large
Thanks advanced for help
Bookmarks