Macro which can countif on multiple criteria and export result

[Closed]
Report
Posts
1
Registration date
Wednesday January 16, 2013
Status
Member
Last seen
January 16, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have to create a macro, which can count for me how many of different categories of services we have.
there are around 20 main categories and 2 subcategories. So eg i have to make the macro count how many of the category AM-AM, with the state *candidate* with the suffix s
The result should be exported to another sheet.
Please help me. I really tried everything
I am working in excel 2003

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you post a sample book at some public file sharing site like speedyshare and post back link to the actual file back here. Using that file as basis please re-explain what you seek