Macro to copy paste from a different workbook

ljuarez

New Member
Joined
Apr 17, 2014
Messages
4
I have two workbooks. I need to copy a row from workbook A and paste it 17 times on workbook B and repeat this until I've gone through all the rows in workbook A (approximately 480 rows).

Steps:
1) I need to copy A1:E1, A2:E2, A3:E3....A480:E480 from workbook A to workbook B.
2) On workbook B, column F will be the product of E x 17
3) I will need to insert a column after E. This column will have the dates from 9/1/14-1/1/16

This is a sample from workbook A cells A1:E1

651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE$2,000.00

<tbody>
</tbody>


I need the output to look like this on workbook B

651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE9/1/2014$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE10/1/2014$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE11/1/2014$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE12/1/2014$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE1/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE2/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE3/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE4/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE5/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE6/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE7/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE8/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE9/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE10/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE11/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE12/1/2015$2,000.00$34,000.00
651-631FA631F-CPA631F-CPMGFEE651-MGMT FEE1/1/2016$2,000.00$34,000.00

<tbody>
</tbody>






























































I then need the macro to go back to workbook A and copy A2:E2 and copy it 17 times like above, and keep repeating this all the way to row 480 on workbook A.

Right now this is a manual cut and paste process. I have two other workbooks I need to repeat this process on.

Thanks,

Luis
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,109,453
Messages
5,528,871
Members
409,842
Latest member
mfernandezcean
Top