ADVANCE-FILTER -- quite difficult :-> need some exp

[3xxx]

:->

Hi, got something cool I would like to achieve

if it is in ACCESS, so simple, just MINUS QUERY


====
but in EXCEL, need your ASSISTANCE

about VBA program with advanced filter
-- just what advanced filter code look like >>> (not really relevant to this Q)

Range(LowestColumnAlphabet & "5:" & HighestPlusPlusPlus & FinalRow).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
Range("AS1:AS2"), CopyToRange:=Range("C" & LowestColumnAlphabet & "5:C" & HighestPlusPlusPlus & "5 "), Unique:=False



============ say, I would like to use advance filter or with some other method (can't use autofilter though-- the limitation, could use looping but this is inefficient last resort )



THE QUESTION >>>

Advanced FILTER
-- say [Supplier ] column those NON-blank one



==== if it is access, just do a query for (those with value ), then do a minus query >> ALL - (those with value)



just wonder, any method (want to avoid autofilter as it can't paste the value in sequenced ROWS later after using autofilter)


welcome any suggestion, welcome any print-screen examples



many thanks

 

[XLGibbs]

it is not singling you out. Your request was cryptic and unclear, and it is course work!

 

[3xxx]

almost figure out myself >>

say set 2>>

set 2)
[supplier code] got something there (i.e. non blank)

[Active supplier] is NO
[Month] JAN to OCT
[DISUSE] = "Yes"


OUTPUT>>> for all rows satisify this coniditon -set 2
>>>>>> >>put the word "found" in Column AA


===================


I could simple use advanced filter

[Month] JAN to OCT
[DISUSE] = "Yes"

then SORT

the [supplier code] column

then remove

all the row with blan cells in [suppler code] column


then I left with all those row that satisfy 3 conditons


===

that is not the most clever way, but I should focus more on simple method


(read it somwhere in a web page, few functions of EXCEL got bug in it if we do too complicated stuff with it, one of them is ADVANCEDFILTER)

======= LEAVE any possible Stratgey and sample code and sample data, if you know how to put those screen capture here ===

thanks !! -- THREAD still OPEN for discussion