Debating_Earth
New Member
- Joined
- Jun 17, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello All,
My apologies--I am very new to VBA.
I am trying to use the program to complete the following list of action items:
1. Create (and save) a new workbook
2. Copy 5 columns from the original file ('Wall^M Forecasting...') and paste into the new file (call it 'Simulated Jobs')
3. Repeat this paste process 100 times, stacking the 20 roes from the original copy, and pasting at the next blank row each time
I am basically halfway done--but I cannot crack step 3 outlined above. Here is what I have done so far: again, I am new to the program, so my apologies for the crude code:
This works perfectly for one scenario, or those first 20 rows. Any ideas on how to replicate this 100x? All suggestions would be greatly appreciated!
Thanks
My apologies--I am very new to VBA.
I am trying to use the program to complete the following list of action items:
1. Create (and save) a new workbook
2. Copy 5 columns from the original file ('Wall^M Forecasting...') and paste into the new file (call it 'Simulated Jobs')
3. Repeat this paste process 100 times, stacking the 20 roes from the original copy, and pasting at the next blank row each time
I am basically halfway done--but I cannot crack step 3 outlined above. Here is what I have done so far: again, I am new to the program, so my apologies for the crude code:
This works perfectly for one scenario, or those first 20 rows. Any ideas on how to replicate this 100x? All suggestions would be greatly appreciated!
Thanks