Cross Referencing nightmare

[Watchdawg]

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?

 

[seguin85]

I have done something like this in the past, I don't use a userform but maybe you can use some of the code for your purposes.
This is an example of my sheet:

	A	B	C	D	E	F
1	Name	Em2
2	Date	12/12/16	Button
3	Points	3
4
5	Dates	Em1	Em2	Em3	Em4	Em5
6	12/12/16		3
7	12/19/16

<tbody>
</tbody>

In Cell B1 I have a drop down of all employees, B2 has data validation to only accept dates listed on that sheet.

So you enter info in B1, B2, B3 then click the Button and it populates the matrix. The code is:

Sub Button2_Click()

Dim Employee As String
Dim Date1 As Date
Dim Points As Double

Employee = Range("B1")
Date1 = Range("B2")
Points = Range("B3")

colnum = Range("B5:L6").Find(Employee).Column
rownum = Range("A6:A30").Find(Date1).Row

Cells(rownum, colnum) = Points


End Sub

 

[Watchdawg]

Re: Cross Referencing nightmare - Updated

Didn't see how to update the original post. I thought I had copied the sample but I didn't. So now I will
https://www.dropbox.com/s/in8ncnxd3kzdg99/SAMPLE Points Balance - PTO.xlsm?dl=0