Range("L67").Select
Selection.Copy
Range("K67").Select
Application.CutCopyMode = False
Selection.Copy
Columns("A:E").Select
Selection.Replace What:="10_7_2018", Replacement:="10_8_2018", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("M67").Select
Selection.Copy
Range("K67").Select
Application.CutCopyMode = False
Selection.Copy
Columns("A:E").Select
Selection.Replace What:="10_7_2018", Replacement:="10_8_2018", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("N67").Select
Selection.Copy
Range("K67").Select
Application.CutCopyMode = False
Selection.Copy
Columns("A:E").Select
Selection.Replace What:="10_7_2018", Replacement:="10_8_2018", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("O67").Select
Selection.Copy
Range("K67").Select
Application.CutCopyMode = False
Selection.Copy
Columns("A:E").Select
Selection.Replace What:="10_7_2018", Replacement:="10_8_2018", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("P67").Select
Selection.Copy
Range("K67").Select
Application.CutCopyMode = False
Selection.Copy
Columns("A:E").Select
Selection.Replace What:="10_7_2018", Replacement:="10_8_2018", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("Q67").Select
Selection.Copy
Range("K67").Select
Application.CutCopyMode = False
Selection.Copy
Columns("A:E").Select
Selection.Replace What:="10_7_2018", Replacement:="10_8_2018", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("R67").Select
Selection.Copy
Range("K67").Select
Application.CutCopyMode = False
Selection.Copy
Columns("A:E").Select
Selection.Replace What:="10_7_2018", Replacement:="10_8_2018", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Any Help would be appreciated!
Bookmarks