Counting Yes's

[TShelt]

Hi guys,

I have 5 sheets; 'ResCap', 'IBMHP', '3rd Party', 'Match and Report', and 'Manual'

Each of these sheets has a combination of 'yes' and 'no' for XYZ reason.

I was wondering if someone could help me come up with a macro that would count every "yes" found on all 5 tabs.

Thanks for the help.

[JieJenn]

Can you attach a sample workbook

[TShelt]

Yes. Let me take off some of the data - give me 3 minutes

[TShelt]

There - as you can see, some tabs dont have any and some do. For this example i would want to find out that there are 14 "yes" total throughout the 5 tabs...if that makes sense? Please let me know if you need more info, thanks so much.

[TShelt]

Jie, did you have a chance to look at this - attachment is on original post.

[JieJenn]

So you just want the total # of Yes in all worksheets right?

[TShelt]

Correct. Just the total Yes count for all 5 worksheets

[JieJenn]

Give me 20 mins. At work right now, but give me 20 mins.

[JieJenn]

Please Login or Register  to view this content.

[JieJenn]

How do you like peoplesoft? I never used it before.

[TShelt]

I tried running that on the example i posted above, I am not getting any msgbox or error. Trying one more thing, gimme a minute

[TShelt]

Nvm, got it! Thanks so much!

[JieJenn]

Anytime. If you ever need help just pm me.