I have 2 separate workbooks; one (let's call it 'Orders') is used for order tracking, the second (let's call it 'Export') is an export file that contains details of the orders received that day. There could be 1 to ‘x’ orders received in a day. The data from ‘Export’ on worksheet(“Sheet1”) in columns A:S needs to be copied and pasted into ‘Orders’ on worksheet(“Order Data”) into columns H:Z starting in the first row where column H is blank.
Here’s where things get over my head: I need to accomplish this by copy and pasting one row at a time because each row needs to be pasted n times where n= the value located in column S. For instance, if S2=’4’:
Hopefully that makes some sense but please let me know if you have any questions or a more complete example would be helpful. Thanks so much in advance.
Here’s where things get over my head: I need to accomplish this by copy and pasting one row at a time because each row needs to be pasted n times where n= the value located in column S. For instance, if S2=’4’:
- I need the loop to select the array Workbooks(“Export”).Worksheets(“Sheet1”).Range(“A2:S2”)
- Find the first blank cell in Workbooks(“Orders”).Worksheets(“Order Data”).Column(“H”)
- Paste the array in that row and the next 3 rows (so the row is pasted a total of 4 times, equal to the value found in “S2”)
- Then repeat for the ‘x’ number of orders in the “Export” file
Hopefully that makes some sense but please let me know if you have any questions or a more complete example would be helpful. Thanks so much in advance.