Error Msg: Extract Range has a missing or Illegal field Name

  • Thread starter Thread starter bumblebee
  • Start date Start date
B

bumblebee

HI,
I am trying to do an advance filter for 10 out of on
about 450 records when I hit the above error message.

I have got more than 10 rows sitting above the 450, with
one column populated with the criteria I want.
The first row (A)is copied from the header row of the 450.

Advance FIlter:
check Copy to another location
List Range: A18 : P:479
Criteria: A1:P11
Copy to: A2

did I miss something?

thanks,
Bumblebee
 
Hi
You can't have the extract range in the same place as the criteria
Amend the "copy to" address to point to a range out of your criteria
HTH

Cordially
Pascal
 
Back
Top