Advanced filter - Illegal Field Name

[Guest]

I have been using the advanced filter for weeks with no problems. Suddenly, when I extract the filtered data to another location (on the same sheet), I get the message: Extract range has missing or illegal field name

I have copied the table field names to the extract location. I have copied the table field names to the criteria area. I have also tried using a reference formula i.e. an extract field name = a1 (the original table field label).

I am very perplexed because, as far as I can tell, I am not doing anything different than I have in the past. Any help would be greatly appreciated

--Beverly

 

[Jim Rech]

I might suggest looking at one of the names Excel creates automatically when
you do an AutoFilter. (In the Define Name dialog, conveniently reached by
Ctrl-F3). "Extract" should be just the header cell in the extract range.
Excel seems to be unhappy about the definition of this name, I don't know
why but perhaps you can figure it out.

--
Jim Rech
Excel MVP
|I have been using the advanced filter for weeks with no problems.
Suddenly, when I extract the filtered data to another location (on the same
sheet), I get the message: Extract range has missing or illegal field name.
|
| I have copied the table field names to the extract location. I have
copied the table field names to the criteria area. I have also tried using
a reference formula i.e. an extract field name = a1 (the original table
field label).
|
| I am very perplexed because, as far as I can tell, I am not doing anything
different than I have in the past. Any help would be greatly appreciated.
|
| --Beverly