Copy, paste, calculate and loop

[williampdx]

Hello there.

Am in need of some assistance to create a macro that will be an amazing time saver.
I have built this sample file for the sake of simplicity. If anyone can assist me with this task on this spreadsheet then I can recode it to work in the real file.
The real file is a very hefty tool for testing financial data.

Here are the steps I need the macro to perform:

With the file open and calculation set to manual, I need the macro to:

1. Copy cells from worksheet !VARIABLES C23:33
2. Paste Special > Values into worksheet !TESTER C10:C20
3. Calculate (in the real file, this can take up to 20 seconds)
4. After calculation is complete, COPY from worksheet !TESTER C23:C33
5. Paste > Values into worksheet !RESULTS C23-C33

Then, it should LOOP back to step 1 and repeat, except that:

Step 1 Should copy the next column over inside the VARIABLES worksheet (ie D23:D33, E23:E33, and so on) every time this loops until it reaches the cell that says "END" in $V$10
Step 5 Should copy the next column over inside the RESULTS worksheet (ie D23:D33, E23:E33, and so on) every time until the macro ends because the condition in step 1 is met ("END" found in $V$10)

Steps 2-4 are exactly the same.

Again, this is a sample file and is purely for functionality.
I really appreciate any assistance I can find on this.

Thanks again!

William