|I have the following macros which I want to run whenever certain cells change as follows:|
1. Condition 1/Macro 1:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("critical_date")) Is Nothing Then
I want to tell the computer to run a macro that goes to cell A8, worksheet, "Shearwater Input", each time there is a change in cells (J9, J10....J22) to "SWA_P".
Both change event macros are in a sheet called "Input".