Hi,

I want to Count the occurence of two words ("Yes" & "No" ) from Column G Say from G1 to G500 and
return the "Yes " count to cell in I42 Column in another sheet & "No" count to K42 column in another sheet
Thanks in advance for the reply..Kindly help me with VBA code to implement this logic. EX:

..............Column A...........................Column G

Row 1....Condition...........Output........Yes

Row 2....Condition............Input..........NO

Row 3.....Condition............Output........NO