Resetting data

We just want to help get you want want.

So this code below just auto saves the file before the user closes it. You can just add the Workbook_BeforeClose info below into the earlier sample. Remember this code goes in the "ThisWorkbook" code in your VBA editor.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
     ThisWorkbook.Save
End Sub

Private Sub Workbook_Open()
    
    
    Worksheets("Counter").Range("A1").Value = Worksheets("Counter").Range("A1").Value + 1
    Worksheets("Sheet1").Range("A1").Value = Worksheets("Counter").Range("A1").Value
     
End Sub