Forum Discussion
Plz help with employees criteria
I need to construct vba for following
4 teams, each team 4 members
Each member with 4 criteria ( does he wear safety helmet? ) In form of questions with yes or no answers
This entry for all teams to be daily
Then collect compliance statistics per period for selected employees
I know excel, but vba none
I think a sheet with headers in first row (team, member, question, answer, date) then a button when clicked enters the data into another sheet, then a 3rd sheet that retrieve statistics based on headers (like when selecting a certain member for certain period of time, it calculates yeses divided by days per selected criteria)
Any help?
4 teams, each team 4 members
Each member with 4 criteria ( does he wear safety helmet? ) In form of questions with yes or no answers
This entry for all teams to be daily
Then collect compliance statistics per period for selected employees
I know excel, but vba none
I think a sheet with headers in first row (team, member, question, answer, date) then a button when clicked enters the data into another sheet, then a 3rd sheet that retrieve statistics based on headers (like when selecting a certain member for certain period of time, it calculates yeses divided by days per selected criteria)
Any help?
This is a duplicate post. Please see this link for the corresponding answer:
