Same solver, multiple worksheets

  • I have 33 worksheets setup in exactly the same configuration (33 equities). Each is populated with different raw data sets, updated daily, then daily ratios are calculated from the progressive data set. I have a macro that calls Solver six times on each sheet bi-weekly and I use the maximum returned values for making purchase bids. Occasionally, I add a new ratio column. This requires changing the solver parameters of objective cell, variable cell range, and the constraint ranges on each worksheet. Currently, I manually update (load and replace) the Solver conditions for each worksheet, but this takes many repetitive steps. Is there a way to load the solver conditions once and have them apply to all worksheets, preferable within my Solver calling macro?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!