I’ll try and shorten the task to its smallest part as each source row has 52 columns and I have 1000’s of row to reformat.
I need to copy data from
sheet1 Row1 columns ABCD to sheet2 row 1 and repeat like this
Row1 columns ABCE to sheet2 row 2
Row1 columns ABCG to sheet2 row 3
then go to next row (2) in sheet 1 and repeat
Row2 columns ABCD to sheet2 row 4 and repeat like this
Row2 columns ABCE to sheet2 row 5
Row2 columns ABCG to sheet2 row 6
I've started with the code below then really got stuck with how to procede. Any help would be greatly appreciated.
Bookmarks