Use the Data>Table command. Look in Help for instructions.
It is a bit of careful work to set up, but it works perfectly.

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
Hi Niek,
Do you know if all the values, formulas, calculations need to be in
the same sheet? I get an input reference value invalid error and i've
read some posts on other websites that indicated everything needed to
be in one sheet...is that true? that seems awfully messy...is there a
workaround? in my particular case, there is a sheet A that contains
the value I'm trying sweep through, a sheet B that has the
calculations by referencing that value, and a sheet C that i've put in
that has in one column the range of values i'm trying to sweep thru in
one column, and in the adjacent column, the formula (this is the
layout recommended in the help)..any ideas what i'm doing wrong to get
that error?
> Use the Data>Table command. Look in Help for instructions.
> It is a bit of careful work to set up, but it works perfectly.
[quoted text clipped - 38 lines]
> | initial value of sheet B, do the calculations, and return that final
> | value to that locations...any ideas?
Niek Otten - 19 Dec 2007 10:15 GMT
I have an article describing how to do this, but it's a bit lengthy so I'll mail you privately, if you don't mind.

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Hi Niek,
| Do you know if all the values, formulas, calculations need to be in
[quoted text clipped - 51 lines]
| > | initial value of sheet B, do the calculations, and return that final
| > | value to that locations...any ideas?