Macro to Automate Goal Seek in Multiple Sheets

[Dan12345]

Hi there,

I have a workbook consisting of three sheets. Sheets 2 and 3 are dependent on the values input into sheet 1. I am trying to develop a macro to automate goal seek in sheet 3 to find a value which I can then copy back over to sheet 2. This is the code I am using just now, obtained from an earlier post in this forum:

Private Sub Worksheet_Change(ByVal Target As Range)
Range("O23").GoalSeek Goal:=Range("O24"), ChangingCell:=Range("O26")
End Sub

I copied my goal seek target over from sheet 2 to sheet 3 and the code is working successfully in sheet 3. However, after changing the inputs in sheet 1 (which will then change the goal seek target as intended), the goal seek calculated cell in sheet 3 is not changing until I manually go into the sheet itself and click a cell.

Sorry if I haven't explained this well, I'm new to using macros in excel.

 

[Dan12345]

crossposted to Macro to Automate Goal Seek in Multiple Sheets (excelforum.com)