How do I make an Excel Table update every time I use it?

e.g -----> 1 2 3 4 whenever I use it

Any help is appreciated.

Try this macro.

Press Alt + F11 > select ThisWorkbook > paste in the code below. Every time you open the file it will increment cell A1 in Sheet 1 (change the reference A1 to whichever cell where you want this to happen)

Excel -- VBA -- Adding Code to a Workbook

Code:

---

Public Sub Workbook_Open()
  Dim Rng As Range
  Set Rng = ThisWorkbook.Sheets(1).Range("A1")
 
    With Rng
        .Value = .Value + 1
    End With
   
End Sub

---