Automatic Goal seek
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.
You can try this macro.
Dim aln As Range
With Sheets(“Summary inst”)
For Each aln In .Range(“d6:d24″)
aln.GoalSeek Goal:=aln.Offset(0, 3), ChangingCell:=aln.Offset(0, 1)