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

Hi again,

I have done some changes in the file so t will be easier.

I have also managed to make a macro for so the column C will change column D. But is a easier way to write the macro so I don't need to write line by line?

Macro7 Macro
'

'
Range("D6").GoalSeek Goal:=Range("g6"), ChangingCell:=Range("E6")
Range("D7").Select
Range("D7").GoalSeek Goal:=Range("g7"), ChangingCell:=Range("E7")
Range("D8").Select


And how do I do the macro automatic, so when I change column G the column D will change right away.

Thank you,

But how do get column D to change automatically when I change column G?

Originally Posted by Storemannen

Thank you,

But how do get column D to change automatically when I change column G?

You should repeat macro by changing Ranges: Range("d6:d24") for every part of sheet.