I am having just about the same exact problem at work. The only way that I have been able to do it so far is to record a macro
that runs the Advanced Filter (in place) then the macro copies the data to another location on let's say "Sheet2". The only issue that I am having is that it does not work every time I run it. It seems that its only allowing me to get the unique values once and that's it....
Other than that I am completley lost on how to solve this one.


Simeon