Hopefully someone can help me with this! I have a spreadsheet that tracks employee's attendance points. There is a tab for 2013, 2014, etc.
The employee names are in Row 2 - B2:Y2
The dates are in column A broken up by month
My userform has 3 areas, Name, Date, and points accrued.
When I click "Save", i need it to find the employee's name, match it up with the date, and populate that cell with the points accrued that was entered on the form.
Example: Employee 1 (B2), got 1 point on January 18. When I click save, B22 (1st employee 18th of January) now should read 1.
Any ideas?
The employee names are in Row 2 - B2:Y2
The dates are in column A broken up by month
My userform has 3 areas, Name, Date, and points accrued.
When I click "Save", i need it to find the employee's name, match it up with the date, and populate that cell with the points accrued that was entered on the form.
Example: Employee 1 (B2), got 1 point on January 18. When I click save, B22 (1st employee 18th of January) now should read 1.
Any ideas?