In the meantime I only need to solve an automation problem: calculating the maximum value of G5 for all possible variations of G2 and G3. It's going to be implemented in a number of similar cases. I have no knowledge of VBA but I know the only way to automate such calculation instead of manually clicking "Solver" every time for the solution is by working on VBA.
(By the way even Solver cannot find the accurate solution all the time, it finds the solution by trial and error and it tests only a range which is narrowed-down by the past calculations it already ran through, but in many times it skips looking in a different range which may contain the real solution. )
I have completely no idea what it takes to finish this task. Do I have to learn VBA from zero and reach a certain level before I can solve the specific problem above? If so how long does it take in general? Is it worth the time or maybe is it better to outsource it so someone with that knowledge can finish it in minutes instead of me figuring that out in days or months? Or do we have a simple VBA template to copy and paste, changing the cell reference to make it done?
Please enlighten me, very much appreciated.
Bookmarks