Goal seek multiple cells
 

Can you embedd goal seek into a formula so that multiple cells can be goal
seeked rather than a single cell at a time ?? If not is there another
function that could achieve the same outcome?

Depending on the nature of your problem...

1. Check out the Solver. (Tools Addins select Solver, then go to
Tools Solver). It enables you to select more than one cells for
changing.

2. If you want to repeat a goal seek for diff cells, try VBA solution
and goal seek separately for each cell.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=393176