I need help with finding a way to save my weekly schedule, to a different
name, and also how to clear it each week. Can anyone help?

You could add a button and then add some code behind the button. Maybe
like so:

Private Sub CommandButton1_Click()
Dim sNewFileName as String
sNewFileName = "C:\File_" & Format(Date, "YYYYMMDD") & ".xls"
ThisWorkbook.SaveCopyAs sNewFileName
Sheet1.Range("B2:B20").ClearContents
End Sub


smilingangel wrote:
I need help with finding a way to save my weekly schedule, to a different
name, and also how to clear it each week. Can anyone help?