Hi,
In cells H10, I10 and J10, I have three input values. The output result is shown in cell I14. I want to find those input values for which the result in cell I4 is maximum. I know that without defining the Limits of input numbers, the code will give infinite values of inputs and will keep on running for an infinite time. So, I have made limitations for inputs numbers which are described in Column B and C.
At the Beginning:
In the first Run, all 3 inputs will be according to cells B10=1 (Input 1), B11=0.01 (Input 2) and B12=1 (Input 3). So, in the first run code will write H10=1, I10=1 and J10=1. Then it will remember this output value.
In the second Run, only input 1 will increase while the input 2 and input 3 will remain unchanged. In column D from cell D10 onward, I have written Values with respect to which input values has to be increase after every Code Run. For input 1, I have written interval of 1, so, in the second run, its values should be increased by 1 and then it should be analyzed. So, in the second run code will write H10=2, I10=1 and J10=1. Then it will see if the output result is bigger than the previous one or not. If these inputs give higher output value than the previous then it should write these input values in N8, O8 and P8. And so on.
This code will keep on running by changing of input 1 only until it reaches its last limit 100. After this input 1 should be taken as 1. Now input 1 and input 3 will remain unchanged. Input 2 will change only by values of 0.01 (as shown in cell D11). This will keep on going until input 2 will reach its end limit of 100.
Then after this, value of input 1 should be increased by 1, now input 1 will become 2. Now input 1 and input 3 will again remain unchanged. Input 2 will change only. And so on,
In short, I want to find those top 10 inputs combinations at which these inputs give highest output result in cell I14.
I do not know anything about VBA Coding. If this task is possible with VBA then please do this. If not then please suggest me a way with which I can do this task.
Please see attached sample file for more clarification
I am using Excel 2021
Bookmarks