Hey guys, I’d be really grateful if you please help me with some lines of code for following problem.
I have 3 sheets. (let’s say 1, 2 & 3). Sheet 1 contains 7 cell values (A1 to A7). Sheet 2 contains 350 cell values (A1 to A350). And finally Sheet 3 is blank.
I want to enter Sheet 1&2 data into sheet 3 with the following order:
Sheet3! A1 = Sheet2!A1
Sheet3! A2:A8 = Sheet1!A1:A7 (Sheet1! Cells repeat every time)
Sheet3! A9 = Sheet2!A2
Sheet3! A10:A16 = Sheet1!A1:A7
Sheet3! A17 = Sheet2!A3
And so on …….
Until it gets all data from Sheet2!
Thank you very much
Bookmarks