#1   Report Post  
 
Posts: n/a
Default solver

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver and dynamic ranges tim Excel Worksheet Functions 0 May 5th 05 01:29 AM
Solver Problems Walker Excel Worksheet Functions 2 May 2nd 05 07:33 PM
question on excel Solver Avalon Excel Worksheet Functions 1 May 1st 05 05:35 PM
Excel: Solver leo Excel Worksheet Functions 1 April 29th 05 02:02 AM
solver constraint jojo Excel Worksheet Functions 0 February 17th 05 10:11 PM


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"