Home |
Search |
Today's Posts |
#1
|
|||
|
|||
missing or ill egal extract range advanced filter
I am trying to use the Advanced Filter in a macro routine. If I include all
of the fields from the list, the macro works with my Copy to location, A1:K1. If I change my Copy to location to exclude irrelevant columns, I change the range to A1:G1. Every time I do this, I get an error messge: "The extract range has a missing or illegal field name." Since the filter runs fine, if I include all the field names, I assume I must have one missing. I'm copying and pasting the values, so the Copy to field headings match the list's field headings. Here are the criteria, if that could have anything to do with it. Two conditions on one column and one condition to compare two columns. Course,Course,(No Header); <Room Rentals,<Career Days,=OR(Source!J2<"",AND(Source!K2<"",Source!K2 <"Consumer")) Thanks, -- tj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced filter criteria "begins with" and "does not begin with" | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |