Thank you so much! I was able to create a macro to copy the data upon opening the worksheet to a second sheet where I can edit the Absent/Present Values there (I copied the code you gave me to both sheets to get the same outcome. This will work perfect for what I need. I appreciate all your help...This was challenging as it my first time even thinking about Macros and VBA.
Sheet 1:
Private Sub Worksheet_Activate()
MsgBox ("Make Client Assignments via this Worksheet")
Worksheets("Split Skills").Range("A1:BB40").Copy Worksheets("Daily Team Coverage Tool").Range("A1:BB40")
Application.CutCopyMode = False
End SubPrivate Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, c As Range, calc As Integer
Set r = Intersect(Target, Range("I5:AI6"))
If r Is Nothing Then Exit Sub
With Application
.ScreenUpdating = False
.EnableEvents = False
calc = .Calculation
.Calculation = xlCalculationManual
End With
For Each c In r
If c.Value = "Absent" Then _
Range(Cells(6, c.Column), Cells(26, c.Column)).Value = "Absent"
Next c
With Application
.ScreenUpdating = True
.EnableEvents = True
.Calculation = calc
End With
End Sub
Sheet 2:
Private Sub Worksheet_Activate()
MsgBox ("Manage Daily Absences and Client Coverage Via this Worksheet.")
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, c As Range, calc As Integer
Set r = Intersect(Target, Range("I5:AI6"))
If r Is Nothing Then Exit Sub
With Application
.ScreenUpdating = False
.EnableEvents = False
calc = .Calculation
.Calculation = xlCalculationManual
End With
For Each c In r
If c.Value = "Absent" Then _
Range(Cells(6, c.Column), Cells(26, c.Column)).Value = "Absent"
Next c
With Application
.ScreenUpdating = True
.EnableEvents = True
.Calculation = calc
End With
End Sub