There are many ways to do that using VBA.
But there is a way to do that just using formulas: introduce a formula which
subtracts the result from a cell (in which the required result is stored)
and then goalseek for the value zero.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"cchristensen" wrote in message
...
Is it possible to create a macro using goal seek that will automatically
reference a cell in the worksheet for the "To value" field, rather than
having to enter a value? I've tried copying/pasting a value into this
field
while recording a macro, but the dialog box doesn't allow that.
My goal is to allow a user to enter a target value (retail price, in this
case), then have a macro activate solver to find the minimum number of
units.
Any ideas?
|