Ben has attended:
Excel Advanced course
Solver
I have several sets of data which I am running solver on. Each data set is the same size and shape and has the same constraints, the only difference is that they are in different columns. If I wanted a quick way to run solver across each column of data, can I use macros do it, or is there another way within solver to successfully carry out all the solver calculations quickly, instead of one by one?
Many thanks
Ben
RE: Solver
Hi Ben, thanks for your query. You can select non-contiguous ranges of cells for Solver to run on but this will come up with only one solution by modifying all those cells at once, and I'm not sure that's what you want. Solver doesn't provide a facility to run multiple instances one after another automatically and the only way to do this would be to record some macros. If you did that, you could attach those macros to command buttons on the spreadsheet and run them at the click of a button, or you could create a master macro which ran the lot.
Hope this helps,
Anthony
