Counter sums quantity of files in said folder but doesnt update unless double clicked

[BigError]

Open Excel... Right Click on a worksheet Tab and choose "View Code."

Above the Code page, thee are two DropDowns, General and Declarations.

Drop down the General and select Worksheet. Then...

Drop down the Declarations and look at all the Events that occur on a worksheet. Pick one to be the Trigger of your code.

I followed your instructions and chose

Private Sub Workbook_Open()


End Sub


Private Sub Workbook_SheetTableUpdate(ByVal Sh As Object, ByVal Target As TableObject)


End Sub


Private Sub Worksheet_SelectionChange(ByVal Target As Range)


End Sub

It doesnt really do anything though. sorry man... Im super new to this.