Hi everyone,
I am new to this forum and beginner with VBA.
If someone would be able to help would be great.
I got one sheet as a “StatusSheet” and I want to count ( yes, no, N/A ) on separate sheets ( total sheets 21, Area_1, Area_2, Area_3, ….Area_21).
The Yes, No, N/A value always will be saved in the same column, between AQ4:AQ200.
At them moment I got
=SUM((COUNTIF(‘Area_1’!$AQ$4:$AQ$200,"Yes"))) ‘to count YES value
=SUM((COUNTIF(‘Area_1’!$AQ$4:$AQ$200,"No"))) ‘to count No value
=SUM((COUNTIF(‘Area_1’!$AQ$4:$AQ$200,"N/A"))) ‘to count N/A value
And
=COUNTA(‘Area_1’!$AQ$4:$AQ$200) ‘ to count total in the column.
I would like to have this in macro and put this in the loop.
is any chance to do this ?
Regards
M
Bookmarks