Hi there
I have >66,000 rows of data that I want to put into an advanced filter.
Therefore I have put the data alongside in one sheet and have 2 ranges.
I have used the union method to set the data together - is there any way that this can be fed into an autofilter? Or can anyone think of an alternative work around?
I have >66,000 rows of data that I want to put into an advanced filter.
Therefore I have put the data alongside in one sheet and have 2 ranges.
I have used the union method to set the data together - is there any way that this can be fed into an autofilter? Or can anyone think of an alternative work around?
Code:
Sub drop_down()
'Sheets("report").Select
Application.ScreenUpdating = False
Sheets("data").Select
Dim allrng As Range
Set allrng = Union(Range("raw_data"), Range("raw_data2"))
allrng.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range _
("criteria_1"), CopyToRange:=Range("extract_1"), Unique:=False
End sub