Hello fellow forum users!!!
I have the following code that works great but it only works with one criteria point and I have 2 criteria points that I want to use...
Sub GetChartData()
'DataTable is the "dirty" data containing all of the #REF! errors
Dim DataTable As Range
Application.ScreenUpdating = False
With Sheets("Summary")
Set DataTable = .Range("I1:J72")
End With
'Criteria says get anything that does not have the "#REF!" as a value and return it to the Extract range
DataTable.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("Criteria"), CopyToRange:=Range("Extract")
Application.ScreenUpdating = True
End Sub
So what is the best way to modify this code to include multiple criteria points?
Bookmarks