Advanced Filter to another sheet
 

I did a search and couldn't find the answer I am looking for. I
understand the AdvancedFilter can pull data from another sheet, just
not the opposite.

This is for VBA. Code seems to make sense, and is similar to what a
macro recorded. (I recorded a macro of what I wanted to do, and it
worked fine.)

Any idea what is wrong? Keep getting an Extract Range has a missing or
Illegal field Name error

Thanks a lot.

Application.Workbooks("Docs
DB.xls").Sheets("dbData").Range("E2:E188"). _
AdvancedFilter Action:=xlFilterCopy,
CriteriaRange:=Application.Workbooks( _
"Docs DB.xls").Sheets("dbData").Range("E2:E188"),
CopyToRange:=tempApp.Workbooks(1).Sheets(1).Range( "A1"), Unique:=True

Advanced Filter to another sheet
 

Disregard this, I realized it is it is impossible as I am working with
two different instances of excel application, let alone workbooks and
sheets

Went the easy way and just copied to the data to a location and then
filtered it then deleted the copied data.