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