I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month.
When an employee receives a recognition card you can go to sheet one, pick their name from the drop down list and pick the the month the card was received in from another drop down list.
I want a button that says enter or input or something that then creates a table on sheet two that keeps track of how many times an employee receives a card during that month.
I have my two drop down lists created, I just dont know how to get the data to record into a table.