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
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