Private Sub Worksheet_Activate()
Application.ScreenUpdating = False
Cells.Clear
Range("a1") = Sheets("JOURNAL").Range("g1")
Range("a2") = Sheets("JOURNAL").Range("f1")
Sheets("JOURNAL").Range("a2:m100000").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("a1:a2"), CopyToRange:=Range("a4"), Unique:=False
With Cells: .Interior.ColorIndex = xlNone: .Font.ColorIndex = 1: .WrapText = False: End With
Range("a4").CurrentRegion.Borders.Value = 1
[g:m].Delete: [d:e].Delete
Columns.AutoFit
Application.ScreenUpdating = True
End Sub