Advanced Filter Copy To Another LocationJan 2, 2008
I seem to be having an odd problem with Advanced Filter. When I use the Copy to Another Location option I get an error that:
"The extract range has an illegal or missing field name".
As far as I can tell, there are no blank or missing fields. I did originally have a DATE field but I have renamed this in case it was a "reserved" name but still have the problem.
When I used the filter in place it works correctly.
I am trying to use Advance Filter as opposed to lots of looping, copying and pasting and this is the only snag. I suppose that I could filter in place then copy/paste the results to the other sheet but I'd like to see where I may be going wrong.