Hi,
I'm using the below vba code to populate a value in the next empty for 12 difference rows
example:
what I would like to do is minus off all the previous results in the row after E6 so I can see how many "Y" have been added since it was last ran.
can someone please help
I'm using the below vba code to populate a value in the next empty for 12 difference rows
example:
Code:
Range("E6").End(xlToRight).Offset(0, 1).Value = "=COUNTIF('BoM Data'!C10,""Y"")"
what I would like to do is minus off all the previous results in the row after E6 so I can see how many "Y" have been added since it was last ran.
can someone please help