Hi,
I have been having difficulty figuring out a macro that will copy data from sheet1 (56 records) to sheet2 (210 records) but loop it every 56 lines.
For example:
Sheet1 data - A1:1, A2:2......A56:56
Sheet2 data - A1:abc, A2:def...A210:ghi
Result in Sheet 2
A1:abc, B1:1 to A56:abc, B56:1
A57:def, B57:2 to A113:def, B113:2
This should be looped to paste all the values from sheet1 to sheet2.
Please help!
Thanks so much! - I know in the title it says sheet 3 - please ignore that.
Bookmarks