Created attachment 113519 [details]
test case

s. attached file with bug.

Handling of data area filtering is strange.  There are several bugs and an overall strange behaviour with slightly unpredictable results.

In the attached file I did the following:

1. Populate a 10-column-table with rows of values in sheet NormData
2. Populate a 10-column-table with 1 row of filter-criteria values in sheet Jan (identical table headers)
3. Define 3 areas for data (in), filter criteria (crit) and output area (out) (this one in table Jan as well underneath the crit-area) respectively
4. Mark the data area in NormData and choose menu Data.Filter.Special filter
4a. 1. error: Dropdownlist in dialog window for filter crit. is empty but should be filled with 3 defined areas
4b. fill field with crit-area and click OK: Nothing happens!?
4c: if you alternatively choose the output area in the dialog Options.copy results to: instead, table row indices of in- and output seem to be confused because you see rows starting from the beginning of the ouput table with content from the same row in the input table (instead of the content starting from first row on filtered data)

Sometimes when the output table is updated there are old rows at the end from a previous output.

I believe that input and output indices are confused. Would you please check this. It's an easy to fix problem with strong achievements for professional users.
Regards,
fury