Hello Everyone,
I'm running AF from Sheet4 ("Dashboard") with data from Sheet3 ("MainDATA")
Currently the filter runs on the Sheet3 then the results are transferred to Sheet4.
In order to do this, however, I am activating Sheet3 then at the end of the code activating Sheet4.
It works, but slows the code by a bit. Is there a more intelligent way of going about this?
I'm running AF from Sheet4 ("Dashboard") with data from Sheet3 ("MainDATA")
Currently the filter runs on the Sheet3 then the results are transferred to Sheet4.
In order to do this, however, I am activating Sheet3 then at the end of the code activating Sheet4.
It works, but slows the code by a bit. Is there a more intelligent way of going about this?
VBA Code:
Sub DashAF()
With Application
.Calculation = xlCalculationManual
.ScreenUpdating = False
End With
Sheet3.Activate
Application.CutCopyMode = False
Application.CutCopyMode = False
Range("MainData[#All]").AdvancedFilter Action:=xlFilterCopy, CriteriaRange _
:=Range("BC2:BP3"), CopyToRange:=Range("CA2:CM2"), Unique:=False
Call TransferDashSort 'this transfers the results to the Dashboard on Sheet4
Sheet4.Activate
With Application
.Calculation = xlCalculationAutomatic
.ScreenUpdating = True
End With
End Sub