Advanced Filtering Macro takes out the existing filter

[sachins19]

Hello,

I am unable to use advanced filtering and normal filtering in the same spreadhseet.

To explain I have created two buttons in the s/sheet and have assigned advanced filtering macros to these. When I run this macro (press the button) the existing filter (on column D) goes away. Below is the macro used for one button

-----------------------

Please Login or Register  to view this content.

-----------------------

I want the existing filter (Column D) in the excel to remain and also use the advanced filter Macro. Is there a way out?

Regards,
Sachin

[sachins19]

I've made changes as per the forum rules.

[romperstomper]

You can't use an advanced filter and autofilter on the same range.

[sachins19]

The range is different. The range for the normal filter is B4 to D29. The advanced filter macro is for range C34:DN58.

Please assist

[romperstomper]

Unless you're using Tables, it doesn't actually matter. You can't use both on a sheet at once.

[sachins19]

Not sure if I've understood what you mean. To further explain my question I am attaching a sample Excel.

Please note there is a filter on B2 and C2 already. However when i press either of the button (B25 or C25) the filter on B2/C2 goes away. Is there a way by which I do not have to change anything on the spreadsheet and still retain all filters especially filter on B2/C2?

Regards,
Sachin

[romperstomper]

Convert the top range into a table. Select it, then choose Insert - Table. You can now filter that table and still use your advanced filter code.

[sachins19]

Perfect. This solves my query. Thanks!!

[romperstomper]

Glad to help.