"carry over" filter settings

[JasperD]

Hi guys and girls,

my sheet has 35 columns with data, that user can filter on (standard autofilter).
The sourcedata is in another sheet. I cannot use a pivottable.

When the users presses a button, the source data gets updated.

a) The autofilter gets removed
b) The rows with data get cleared
c) New data gets copied over into the sheet
d) Autofilter gets applied on the columns with data.

Now what I'd want to accomplish is that the new autofilter (after updating the data) gets filtered on the same columns and values as the user had originally filtered on.

What would be the most efficient way to get this accomplished?

Thanks for any help!

Jasper

[LJMetzger]

Hi,

See the file associated with post #4 in the following thread: http://www.excelforum.com/excel-prog...ml#post3883023

The application is slightly different (synchronizes AutoFilter across several sheets), but you should be able to adapt that contents of Sub SynchronizeAutoFilterCriteriaAcrossAllSheets() in module ModAutoFilter to your needs.

Please let me know if you need additional help.

Excerpts from the code are included here for illustration purposes only. The code probably won't run without all the resources included in the referenced file.

Please Login or Register  to view this content.

Lewis

[JasperD]

Hi LJMetzger,

many thanks for your help!
I was googling myself as well and found this post: http://stackoverflow.com/questions/9...defined-filter
That one looks more condensed and less dependent on addins / references, so will try that one first and alternatively use yours.
I'm sure either one works, so closing this thread.
Thanks again,

Jasper

[LJMetzger]

Jasper,

Your welcome and thanks for the rep points.

The link you referenced looks like it will work fine. Unless efficiency and/or speed is an issue, my code tends to be long because it is a lot easier for me to debug that way.

Lewis

[JasperD]

I went for the shortest code I could find and it works absolutely fine:

Please Login or Register  to view this content.

However - I really do appreciate your answer and effort. A lot of times people just have the tendency to not reply. I try to help people on the forum if I can, so appreciate it if I see someone doing the same Have a great day.

[LJMetzger]

Jasper,

Thanks for the feedback and thanks for sharing your final code. It is much appreciated.

Lewis