hi,
I am having a similar problem, how could i do a countif in sheet 5, range G:G counting all the Y and placing them in sheet 1 column D.
Also I have multiple countif's doing the same thing in 5 other worksheets, but they look at different ranges e.g. A:D could i possibly do this in one sub or i have to do different subs for each.