Goal seek: How to set the "to value" to be a number in a cell and not a value

**planjb** · 07-27-2020, 11:56 PM

I would like to set a value for all of column H and I want the value in column D to change based on the set value in column H. I am using the goal seek feature but I'd like to create a macro where I can just type out a value in a cell on the sheet and have goal seek run automatically based on that number instead of having to repeat goal seek in each cell on column H many times for different values. Thank you in advance for reading and please let me know if I can clarify anything!

**Kaper** · 07-28-2020, 08:58 AM

See the hint in a yellow banner near the top of the page.

**planjb** · 07-28-2020, 01:36 PM

Hi Kaper, I added an example of the excel to this post. I hope this helps clarify my question some more. Thank you, planjb

**josephteh** · 07-28-2020, 11:18 PM

If what you want to derive is Input value and Target level refers to % Left, then
E8 = ($I$4*46000+G8-D8)/4400

**planjb** · 07-29-2020, 11:03 PM

Hi Josephteh, this solution is perfect! Thanks

Goal seek: How to set the "to value" to be a number in a cell and not a value

LinkBack

Thread Tools

Rate This Thread

Display

Goal seek: How to set the "to value" to be a number in a cell and not a value

Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

Re: Goal seek: How to set the "to value" to be a number in a cell and not a value

Thread Information

Users Browsing this Thread

Similar Threads

How to create a "goal-seek" type formula for an inventory management file

Trying to automate "Goal Seek" in a worksheet

Using Goal Seek - where I want the "To Value" to be a specific cell

[SOLVED] if formula needed to populate either "1" or "0" based on number of units in another cell

slow "goal seek" responding time:(

How to set the "to value" in GOAL SEEK as a cell reference?

updating without "goal seek"

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions