Hi again, scrappe7,
My apologies. In pointing out Excel's BUGS (that you confirmed DO exist), I neglected to point out that these BUGS are "SPECIAL BUGS" - in that they provide "FALSE" ERROR MESSAGES.
Specifically, when one uses the "manual" method of extracting data to a SEPARATE sheet - using Data - Filter - Advanced Filter, you get the ERROR message.
HOWEVER, if you used VBA, then you do NOT. Here's an example of code that works without problem.
Sub Extract_Data()
Range("Data"

.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:="crit", _
CopyToRange:=Range("out"

, _
Unique:=True
End Sub
This routine requires that you assign 3 range names:
1) "Data" - to your database, with the top row including your field names.
2) "crit" - to your criteria. Criteria consists of a field name, and below it, either a formula or a label. If using a formula, Excel requires that you do NOT use the field name, but you must STILL reference the two cells in your criteria name (in this case "crit"

. You naturally can have different criteria, named differently, for different purposes.
Two cells is the "smallest" size of criteria. You can include as many fields as is necessary in order to "isolate" the data you require.
By including extra fields, you are creating an "AND" condition. You can also include an "OR" condition by including extra ROWS in your criteria.
3) "out" - This refers to the range where you want the data extracted. This name should be assigned to the one row that contains the field names you want to include in your extracted data. This range can be on ANY sheet.
You do NOT have to include ALL the fields in your extraction, and you can change the order of the field names if you prefer to re-arrange them.
Be aware that by using a "1-row" extraction range, Excel will automatically delete ALL data below this range.
Because this area of Excel is NOT very well explained either by Microsoft or by third parties, and because it REQUIRES some explanation and guidance, I thought it would be preferable for you to send me your file. However, if you can "run with the above information", then "all the power to you".
But please start by appreciating that this "extraction" to a SEPARATE sheet is INDEED possible.
Another BUG says you cannot place your criteria on a SEPARATE sheet. Again, this is FALSE - i.e. it IS possible.
I hope the above helps.
If you run into difficulty, please feel free to email me.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca