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?

 

[mangesh_yadav]

Depending on the nature of your problem...

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

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

Manges