Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old November 5th 04, 07:20 PM
cchristensen
 
Posts: n/a
Default Goal Seek - reference a cell for "To value" field?

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?

  #2   Report Post  
Old November 5th 04, 07:27 PM
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?





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Goal Seek - Why make the PV negative? Mytpoet67 Excel Discussion (Misc queries) 1 January 13th 05 02:51 AM
Formula with text and reference to a date cell [email protected] Excel Discussion (Misc queries) 1 January 11th 05 08:15 AM
Using a formula in a Hyperlink Cell reference sslabbe Excel Discussion (Misc queries) 4 December 10th 04 12:30 AM
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 1 December 2nd 04 08:30 PM
cell reference show cell name (ie. D45) and not cell value ria Excel Worksheet Functions 4 November 6th 04 04:38 AM


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017