I am trying to recalculate an asset allocation based on existing holdings that represent constraints to a recommended allocation by adjusting the recommended weightings on a prorata basis if the current holding exceeds the recommended weight. Can I use the solver to do this and if so how do I build a Macro to replicate the solver function.