advanced filter macro doesn't work on large data set

**bullkater** · 11-29-2009, 07:00 AM

Hi everyone on the forum, I’m new here to post.

I have troubles with a large set of data (43’600 lines x 27 rows) that I want to filter with an advanced filter. I want to filter many times according to changing criteria, so I record a macro for an advanced filter with copy to a different place. The problem is that when recording the macro the filter applies and I get the filtered set at the indicated location ->

. But when running the macro nothing is being filtered ->

(the only two things that happen is that two named fields are created (“Criteria” and “Extract”) and at the location of the extraction the header row is written).

I tried the same procedure with a really small set of data (12 lines x 3 rows) and it works fine ->

. Any ideas? If of any help I can send the file.

Any help is very much appreciated. Thank you in advance everyone.

See also here for a similar question:
http://www.excelforum.com/excel-prog...ot-in-vba.html

**Huron** · 11-29-2009, 01:04 PM

I think you'll need to post the file here before anyone can help. Click Go Advanced then Manage Attachments and upload your file.

**bullkater** · 12-01-2009, 03:21 AM

I've been trying to upload for two days now, but I can't due to some security token issues - I don't know what that's about. I filled out a form that told me that an admin will get in contact with me. I'm still waiting.
I might cross-post now.
Thank you anyway everyone.

**bullkater** · 12-02-2009, 08:05 AM

Ok, since I couldn't upload the attachement here, I uploaded it here. I hope no one is offended by that. If you want to have a look over on the other forum, I'd appreciate very much. Fanks.