leighton367
New Member
- Joined
- Jan 28, 2015
- Messages
- 2
Hi to whomever could help me,
I am trying to create a Recognition progam in excel for my employees, and make it user friendly for others. I have created one sheet (Data) that has all the information stored Names and what we are recognizing them for. Then I have the User friendly sheet (YYD) that has One drop down for the name of the employee(Rows in column A on data sheet), and another drop down for the recognition card they recieved (Columns B,C,D,E on Data Sheet). Lastly, there is a button on the User friendly sheet (YYD) and I am trying to get the macro to add 1 to the cell of the row and column they selected on the drop downs, when they click the button.
Drop Down Cells on YYD Sheet- F12 (Names) and F17 (Recognition)
Button (Submit) to add 1 - Sub Submit()
Sample of Data sheet:
<TBODY>
</TBODY>
I am trying to create a Recognition progam in excel for my employees, and make it user friendly for others. I have created one sheet (Data) that has all the information stored Names and what we are recognizing them for. Then I have the User friendly sheet (YYD) that has One drop down for the name of the employee(Rows in column A on data sheet), and another drop down for the recognition card they recieved (Columns B,C,D,E on Data Sheet). Lastly, there is a button on the User friendly sheet (YYD) and I am trying to get the macro to add 1 to the cell of the row and column they selected on the drop downs, when they click the button.
Drop Down Cells on YYD Sheet- F12 (Names) and F17 (Recognition)
Button (Submit) to add 1 - Sub Submit()
Sample of Data sheet:
Name | People | Service | Sales | Credit |
Bob | 4 | 1 | 3 | |
Dana | 2 | 3 | 1 | |
Eric | 3 | 1 | 2 | |
Scott | 2 | 1 | 1 | 1 |
<TBODY>
</TBODY>