Need help for macros that will provide some statistical information per user name...

[erkamu]

Hello,
I have and xls file that consist of 22 columns and might reach up to 20 000 rows.
The essential part of that xls is:
* column E-where I have user name
* column H-where I might have one of the following Categories: "Stype1", "Stype2","Stype3","Stype4", "Qtype"
* column V-where I have 3 values "OK" or "NOK" or ""(empty, no entry)

What is needed from the macros agter execution?
To populate a table located on next sheet where in column A I have list of users and against each user to have the following information:
*how many categories "Stype1", how many of them are having score "OK" and "NOK"
*how many categories "Stype2", how many of them are having score "OK" and "NOK"
*how many categories "Stype3", how many of them are having score "OK" and "NOK"
*how many categories "Stype4", how many of them are having score "OK" and "NOK"
*how many categories "Qtype", how many of them are having score "OK" and "NOK"

In the attached file you will fond a model of the source file (sheet "raw_data" and what is expected to be populated by the macros in sheet "Macros_output"
Bear in mind that each time macros is run we can have different number if rows and different users

Thanks in advance for your bright VBA code.
erkamu

[walruseggman]

Can I ask why you wouldn't use a pivot table for this? Seems like exactly what they were designed for.

[erkamu]

Can I ask why you wouldn't use a pivot table for this? Seems like exactly what they were designed for.

The user who will extract the information will do that multiple times (3 times per day, 1095 times oer year). User is not good in xls that us why we prefer 1 click solution with macros.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[erkamu]

Please help!

[erkamu]

Please help!!!