Hi All,

I have a VERY Excel big spreadsheet and want to do some formula optimization. The only way to it is with a Macro, but I know nothing about them........

I have advertised locally for help and so far nada.

Just by chance is anyone on the forum fluent in Macros?

Fluent enough. What are you trying to do?

email sent with details

I'll take a crack as well if you like.

JP

If you’re still having issues, send it over. I know my way around Excel pretty well.

Thanks guys,

I have a BIG spreadsheet that provides a result based on 4 variables. What I want to do is to increment the 4 variables and capture the best 100 or so results. (Yes, I know this is a lot of calculations)

Below summarizes what I am looking for.

I want to run a simulation of 4 variables (Cells J2, K2, L2, M2) each incrementing from 10 to 200
After each variable increments, Read Cell T15103 and T17287. If the value of T15103 is greater than 90,000, then on another sheet, Paste the 4 variable values in a row in columns A, B, C and D along with the value of T15103 and T17287 in Column E and Column F, respectively.

Then increment Cell J2 and perform above again. After J2 has reached a value of 200, reset it to 10 and increment the value in Cell K2. Continue until all of J2, K2, L2 and M2 have been incremented form 10 to 200. Yes, it’s a lot of iterations, but the result threshold of 90,000 will reduce the output table significantly

For the next set of variables that result in T15103 greater than 90,000, paste the 4 variables and the value of T15103 and T17287 in the same columns as above on the next row down from the previous result.

There will be a cash, giftcard or alcohol based reward for successful completion.

I appreciate your willingness to help!

We have a solution. Thank you guys for trying.

The only bad thing is it will run for a long time........