Hi I'm trying to count a total of holidays days for an employee
Each worksheet is set the same employees down A5:A49 with dates along the top. Each month for each sheet
I'm using vba match to find the row number for the employee
i = Range("a1").value 'employee list in data validation
x = Match(i, range("A5:A49"), 0)
z = countif(sheet1.Range("C" & x, "AK" & x), sheet13.range("O7").value)
Range("K3").value = z
How do I loop this for each month sheet1 to 12 adding up totals pf each month together.
E.g if sheet1 jan = 2
Sheet2 Feb = 4
Sheet6 July = 1
Sheet12 December = 2
The total "z" will be 9 in range("K3")
Thanks
Each worksheet is set the same employees down A5:A49 with dates along the top. Each month for each sheet
I'm using vba match to find the row number for the employee
i = Range("a1").value 'employee list in data validation
x = Match(i, range("A5:A49"), 0)
z = countif(sheet1.Range("C" & x, "AK" & x), sheet13.range("O7").value)
Range("K3").value = z
How do I loop this for each month sheet1 to 12 adding up totals pf each month together.
E.g if sheet1 jan = 2
Sheet2 Feb = 4
Sheet6 July = 1
Sheet12 December = 2
The total "z" will be 9 in range("K3")
Thanks