Howdy,
I would like to write a loop that finds the first empty cell in Table 1, then repeats until x where x equals a value entered into a msgbox. I am attempting to make a Monte Carlo simulator that runs a complex financial planning scenario, copies the results into a table, and repeats for a specified number of trials, x.
Here's the logic flow:
Regards,
Carter
I would like to write a loop that finds the first empty cell in Table 1, then repeats until x where x equals a value entered into a msgbox. I am attempting to make a Monte Carlo simulator that runs a complex financial planning scenario, copies the results into a table, and repeats for a specified number of trials, x.
Here's the logic flow:
- Press button to activate macro
- message box pops up: "enter trial numbers" (x)
- Clear contents from Table 1
- Select and Copy range A1:G1
- Paste in first empty row in Table 1
- Manually calculates "Sheet 1"
- Select and Copy range A1:G1
- Find and paste in next empty row in table 1
- Repeat for x times
Regards,
Carter