PDA

View Full Version : Solver VBA code for multiple sheets



pedrostur
04-07-2016, 05:19 AM
Greetings everyone,

I wanted to ask if there is a way to create a button (VBA) to run solver in multiple sheets at once. To illustrate I will attach the excel file. I have around 100 sheets and the solver arguments are already placed. Moreover, the cells that will change with the solver solution are placed in the same place in every sheet. All the sheets have the same formats, the only thing that changes is the values for the objective function as you can see in the excel file attached.

Hope anyone can help me with this problem. Thanks for your attention and time.

Pedro

pedrostur
04-07-2016, 05:23 AM
I will upload the file in a second. Just noticed the forum only allows to attack 1mb files

pedrostur
04-07-2016, 05:32 AM
I managed to decrase the size of the file and now it is properly attached