Goal Seek Dynamic Range

Hi everyone,

As this is my first post I'd like to begin by saying that 'Excel forum' has been of huge value to me over the years. The issue that I am having
is running multiple goal seeks on each cell within a range.

Within the attached workbook dynamic named range 'TradePr' is Column 'AW' which I require as my .GoalSeek and 'Required_TM' is Column 'AK' as my, ChangingCell:=
- as for the Goal:= this can be set as Range("BI2").value

So essentially if I were to only calculate the first cell within the range it would be:

Please Login or Register  to view this content.

Really appreciate the help.

Thanks

Apologies workbook did not attach.

DynamicRange_Goalseek.xlsx