I am looking for code which will count two color from each sheet that are Green and Pink and here are RGB(244, 204, 204) & RGB(183, 225, 205).
First Code will count that how many cells have green and pink color in column A,B,C,D and so on till used range .
Second Code will create a sheet with summary name and paste the result over there
Third Code will paste sheet names and their headers in summary sheet and thier count for Green and Pink Color.
I have made a summary sheet manually but want a code which will make the summary sheet automatically and paste the Green and Pink count.
First Code will count that how many cells have green and pink color in column A,B,C,D and so on till used range .
Second Code will create a sheet with summary name and paste the result over there
Third Code will paste sheet names and their headers in summary sheet and thier count for Green and Pink Color.
I have made a summary sheet manually but want a code which will make the summary sheet automatically and paste the Green and Pink count.