Goal Seek With Multiple Input Cells

Originally Posted by MrShorty

It is difficult to say for certain without actually seeing the problem, but it sounds like the built in Solver utility should be able to solve the problem for you without VBA.

I'll Take another look at the Solver. I didn't get anywhere when I previously tried to use it. I would post my actual worksheet, but it is huge and complicated. The formulas are daisy chained through multiple links. It has crashed my Excel a few times because of it.

Thanks for the input.

I have retried the Solver add-in and it does almost work, but I still can't figure out how to prevent duplicates. How do you prevent duplicates with the constraints?