Multiple Cell Goal Seek all at once

I'm pretty certain that goal seek will not do that.

Solver might, but I think the version of Solver that comes bundled with Excel is limited to 200 decision variables (by changing cells) or something like that. The Premium version of Solver (see www.solver.com ) can handle larger problems (I am not certain of its limits, but they are published on the website), so that might be worth considering.

Using VBA, one can program Goal Seek and Solver to loop through a series of calculations, I'm not sure how long that would take for the problem at hand.

You have not explained any details about the computation you need performed. I see a lot of "Goal Seek" type problems come across the forum that could be solved much more quickly using some algebra outside of Excel, then program the resulting formula into the spreadsheet. Is this a possibility?

There is nothing unusual or difficult about the algebra, so I would definitely solve this one algebraically:

(using column letters as variables)
1) AA=Z=Y*1E4/T T is a function of our unknown S that we are trying to find, so solve this for T.
2) T=Y*1E4/Z
3) T=S*P9 Solve this for S
4) S=T/P9
5) Set the two expressions for T equal to each other and solve that expression for S. You should now have a formula to put in column S that will find S at any given Z. (I will leave some of the algebra for you to do).

Unless there is something I am missing.