On sheet: "Control Panel"
I have an array ("array1") of cells C7:C28 with text saying either "On" or "Off"
I have an array ("array2") of cells J7:C28 with numerical values
The two columns match, so J7 relates to C7 etc.
I am looking for a macro which
1. records the state (on/off) of array1
2. for any row where array2=0, turn array1 to off
And a second macro that turns it back to the original state