@n0ahc
Hello,
it is possible for VBA to do that. You can automate the filter to run when you open the workbook. To do this, you can use Excel's "Workbook Open" event in VBA.
Private Sub Workbook_Open()
Dim currentDate As Date
Dim dateColumn As Range
' Set the current date to today
currentDate = Date
' Define the range of the date column in your data
' Change "A1:A500" to match the location of your date column
Set dateColumn = ThisWorkbook.Worksheets("Sheet1").Range("A1:A500")
' Clear any existing filters
dateColumn.AutoFilter
' Filter by the current date
dateColumn.AutoFilter Field:=1, Criteria1:=currentDate
End Sub
Replace "Sheet1" and "A1:A500" with your actual sheet name and date column range.
Once you've made these replacements, save your workbook, and the code will execute when you open it, automatically filtering the data based on the current date.
