L
Legacy 366536
Guest
I have written a VBA code for a Userform that allows current employees to track treatment interactions with patients. The code is working with no problems, but the issue I am running in to is I would like to have the charts generate on their own. I manually can run all the data using a pivot table, but I am not sure if there is a better way to write a macro to count the values in the column to graph them. The values of each column are:
Department
Body Part
Injury
Mechanism
Interaction (2 categories)
Interaction Type (comma delimited - may have up to 5 choices)
There are four different charts that are formed:
1. Number of Injuries per body part in each Department
2. Count of Mechanisms per injury in each department
3. Number of Interaction types in Interaction Category 1
4. Number of Interaction types in Interaction Category 2
Is there a way to use the macro to count everything or will I need to continue to do everything by hand? Thank you in advance for your time and consideration.
Department
Body Part
Injury
Mechanism
Interaction (2 categories)
Interaction Type (comma delimited - may have up to 5 choices)
There are four different charts that are formed:
1. Number of Injuries per body part in each Department
2. Count of Mechanisms per injury in each department
3. Number of Interaction types in Interaction Category 1
4. Number of Interaction types in Interaction Category 2
Is there a way to use the macro to count everything or will I need to continue to do everything by hand? Thank you in advance for your time and consideration.
