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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,114,577
Messages
5,548,861
Members
410,881
Latest member
toonces
Top