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
<tbody>
</tbody>
I need the output to look like this on workbook B
<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
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-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | $2,000.00 |
<tbody>
</tbody>
I need the output to look like this on workbook B
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 9/1/2014 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 10/1/2014 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 11/1/2014 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 12/1/2014 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 1/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 2/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 3/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 4/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 5/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 6/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 7/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 8/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 9/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 10/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 11/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 12/1/2015 | $2,000.00 | $34,000.00 |
| 651-631F | A631F-CP | A631F-CPMGFEE | 651-MGMT FEE | 1/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
