Sep 07 2021 11:13 PM
Hi I have a spreadsheet I enter responses from clients each Thur-Sun.
Each week I have to clear the contents before starting it each week.
Is there a way it will clear itself automatically?
Any help would be appreciated.
Cheers, Porcha
Sep 08 2021 12:52 AM
You could create VBA code that clears the cells when the workbook is opened on Monday:
Private Sub Workbook_Open()
If Weekday(Date) = vbMonday Then
With Worksheets("Responses")
.Range("E2:F" & .Rows.Count).ClearContents
End With
End If
End Sub
Sep 13 2021 04:11 PM
@Hans Vogelaar thank you, I will give this a try and let you know how I go :) really appreciate the help. Cheers, Porcha