Private Sub CommandButton2_Click()
ActiveSheet.Unprotect
Application.ScreenUpdating = False
Dim rName As Range
Dim dName As Range
Dim foundName As Range
Dim found2Name As Range
Dim lColumn As Long
For Each rName In Sheets("Moulder 1").Range("C123:H123")
If rName <> "" Then
Set foundName = Sheets("Employees").Range("A:A").Find(rName, LookIn:=xlValues, lookat:=xlWhole)
If Not foundName Is Nothing Then
lColumn = Application.WorksheetFunction.Weekday(Sheets("Moulder 1").Range("C1").value) + 3
If lColumn = 3 Then
lColumn = 4
End If
Sheets("Employees").Cells(foundName.Row, lColumn) = Val(Sheets("Employees").Cells(foundName.Row, lColumn)) + rName.Offset(5, 0)
End If
End If
Next rName
For Each dName In Sheets("Moulder 1").Range("O123,Q123")
If dName <> "" Then
Set found2Name = Sheets("Employees").Range("A:A").Find(dName, LookIn:=xlValues, lookat:=xlWhole)
If Not found2Name Is Nothing Then
lColumn = Application.WorksheetFunction.Weekday(Sheets("Moulder 1").Range("C1").value) + 3
If lColumn = 3 Then
lColumn = 4
End If
Sheets("Employees").Cells(found2Name.Row, lColumn) = Val(Sheets("Employees").Cells(found2Name.Row, lColumn)) + dName.Offset(1, 0)
End If
End If
Next dName
Range("Q124,O124,Q123,O123").ClearContents
Range("C123:H123,Q109,O109,G109,F109,B109,B94,F94,G94,O94,Q94,Q79,O79,G79,F79,B79").ClearContents
Range("Q64,O64,G64,F64,B64,Q49,O49,G49,F49,B49,B64,Q34,O34,G34,F34,B34,Q19,O19,G19,F19,B19").ClearContents
Range("Q4,O4,G4,F4,B4").ClearContents
Rows("7:119").Hidden = True
Range("B4").Select
ActiveSheet.Protect
Application.ScreenUpdating = True
End Sub
Thanks in advance for everything
Bookmarks