How do i apply Goal Seek to a range of cells in Excel

[Mabvuto]

I need to apply a Goal Seek result to a range of cells. i get the error
message ''Reference must be to a Single Cell"
How can i get around this?

 

[ryguy7272]

Excel is doing what it is supposed to do. Goal Seek works on a single cell.
Solver, however, can be used to change a range of cells.

Check this out:
www.informit.com/content/images/0789729539/samplechapter/CH25_0789729539.pdf

This is good too:
http://office.microsoft.com/en-us/excel/HA011118641033.aspx

One more
http://ezinearticles.com/?Tools-From-Advanced-Excel-Courses---Goal-Seek-and-Solver&id=1107843

If you feel really ambitious, read this:
www.decisioneering.com/index.html

Regards,
Ryan--