basic autofilter query ,

Please Login or Register  to view this content.

Can i do 2 advanced filters

Ie ADVANCED FILTER filters the data then I want to filter it futher agaoin.

I have the above code but Range("I1:I300").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"U1000:U1007"), Unique:=True always resets the first filter and then displays the results

for example coloum I shows : john , peter , ian, dev , mark
after filter one it shows john , peter only
I need these unique names , but when filter 2 takes place it displays john , peter , ian, dev , mark
instead of john , peter only

I hope this makes sense, I pray there is an easy fix