Filtering upon opening document without using VB code

[lojanica]

Hi All

I am using the excel for the work ticketing system register and in process to improve my system I am looking to implement flows. However my document is xlsm and flows will not work on macro documents.
The only reason I am using macro is to auto filter upon the opening document.
------------------------------------------------------------------------------------------------------------------------------------------

Private Sub Workbook_Open()
Dim mainwb As Workbook
Set mainwb = ActiveWorkbook
mainwb.Sheets("Job Request Register").Activate
mainwb.Sheets("Job Request Register").Range("A8").Select

If (ActiveSheet.AutoFilterMode And ActiveSheet.FilterMode) Or ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If

Range("A8:BE8").AutoFilter field:=22, Criteria1:=Range("b6")
Range("A8:BE8").AutoFilter field:=36, Criteria1:="0"

End Sub
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
So basically I filter only for two criteria

Colom V = B6
Colom AJ = 0

Can this filtering be done upon opening the document automatically without using macro?

Thank you

 

[Joe4]

Welcome to the Board!

How about having two sheets in your workbook?
The one sheet has the raw data, and the other uses the new FILTER function to dynamically filter the data you want (no VBA required!).

See: FILTER function - Microsoft Support