benlandgren
New Member
- Joined
- Dec 7, 2017
- Messages
- 2
Hi, I have made a spreadsheet where all columns are similar in terms of formulas etc. Only the input values for each column are different. Each column has 4 variable cells that the solver needs to find a solution for. I have tried to make a solver setup that finds solution for the 4 variable cells of all of the columns but it seems to work only sometimes and seems to be computationally taxing.
As all of the columns are independent from each other, I was looking to find a solution to run the solver separately, one column at a time, but I have not been able to find any help on how this could be done. I have seen this been done with goal seek, but I would prefer solver.
I am also quite new to VBA.
Any idea how this could be done?
As all of the columns are independent from each other, I was looking to find a solution to run the solver separately, one column at a time, but I have not been able to find any help on how this could be done. I have seen this been done with goal seek, but I would prefer solver.
I am also quite new to VBA.
Any idea how this could be done?