I am trying to figure a way out to make advanced filter work by displaying results which has blank in them.
Currently, my advanced filter will only show results which are complete (rows which do not have any blank cells in them). I understand that you can use ="=" in the cell to showcase blank cell but for criterias which I leave blank, I would like my advanced filter's results to showcase both the blank results as well as results with answers.
For example:
I have these as my raw data:
F Name L Name Order Qty BirthPlace
John 1111Wood 11111 1111Texas
Pete 1111Silva 111112 11111NY
Jim 1111Fox 1111111111111BF
Marc 111Phillips 11112 111Las Vegas
Louis 111Tyler 1111115 1111BF
When I input my criteria for BirthPlace to be "BF", only Louis Tyler will show up as his is a complete set but Jim Fox has a blank and thus he will not show up.
Any idea on what i can tweak in my formula to make the blanks i.e Jim Fox show up?
My current code is a simple one:
Sub GenerateData()
'
' GenerateData Macro
'
Sheets("Sheet1").Range("A1:Q3530").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("C11:Q12"), CopyToRange:=Range("B14:R14"), Unique:= _
False
ActiveWindow.ScrollColumn = 1
EndSub
Thank you!
Bookmarks