View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

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?