I have a macro that runs and pulls a bunch of data out of access based on
certain criteria. It works fine. Then I go into manually run the solver. I am
maximizing a value and wanting to keep a set of 24 weights, when summed up,
equal to one. Also, the maximum of any of these weights cannot be 2. The
problem is solver just sets all of my weights to the same number. Is there a
way around this? Thanks