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? Plz
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? Plz
1 Reply
You should be able to get the userform working by looking at this userform example file (See attachment) I created a while back. It describes how to make a userform with multiple screenshots, how to link a macro that launches the userform to a shape and then use the userform to collect data and put it one a data collection worksheet. Once you have this price you can simply create the statistics page based on the data on the data collection sheet.
