solver

S

shalini.kashyap

Hi,

I have managed to use solver to find a solution
to a problem, does anyone know of a way to use this
solution repetively like a fill down. I need to use
solver on about 1000 rows of data to find a solution,
and I need the target cell, changing cells and contraints
to advance to the next row,

ie for solution:
1st row: target cell = $A1, Changing cell = $B1, contraint $A1 = $C1
2nd row: target cell = $A2, Changing cell = $B2, contraint $A2 = $C2
3rd row: target cell = $A3, Changing cell = $B3, contraint $A3 = $C3

Thanks,
Shalini
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

what does error message "too many adjustable cells" mean in solver 1
How do I use Excel Solver (for an Iteration in a row) for several no.of times? 0
"DoEvents"-type behavior in Solver? 1
Formula fill series? 1
Solver not working 21
How do I set focus (and select text) on a text box on a modeless userform? 0
Looking to added up based on a character from cell range 1
Search cell value in same column 3

Top