Closed Thread
Results 1 to 2 of 2

Automatic Goal seek

  1. #1
    Registered User
    Join Date
    01-09-2017
    Location
    Oslo, Norway
    MS-Off Ver
    2007
    Posts
    4

    Automatic Goal seek

    Dear all,

    I would like to make a table with automatic goal seek for each line.

    I have attached the file I use and would like the following:

    When I'm changing the " wanted Margin %" column in G column I want the price in column H to change automatically.

    Can somebody help me to make a macro for the entire list so i don't need to make it for each line.

    Thank you-

    Morten

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Automatic Goal seek

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread here http://www.excelforum.com/showthread...t=#post4556146

    Thread Closed.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatic Goal Seek That References Cell For Target Value
    By Navigator16171 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-23-2016, 05:52 AM
  2. Automatic Goal Seek and Calculate Active Sheet Code
    By grifbomber in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2016, 10:42 AM
  3. Automatic goal seek program
    By calltobala in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2015, 03:14 PM
  4. Excel VBA Multiple Automatic Goal Seek Required – Please Assist us
    By champaben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2014, 04:22 PM
  5. [SOLVED] Automatic Goal Seek
    By Talazem in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-04-2013, 11:28 AM
  6. Faster calculation for multiple automatic goal seek
    By lockd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2013, 09:30 AM
  7. Automatic Goal Seek VBA won't work now
    By Brodie05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 08:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1