Hi Excelforum,
I only have Excel 2000
See attached Excel spreadsheet named GOAL RUN MACRO
I would like a Macro which would run Goal Seek the power to which the low of 150 has to be raised give the High value of 638
Colum D = power to which the "Low of 150" has to be raised to give the "High value of 638"
Using Goal Seek manually ... 150 raised to the power of 1.289 = 638
I have only entered one line of High data to keep it simple
But I would like to run the Macro on more than one line of data
Thanking you in advance
Best regards,
Derek
Bookmarks