Advanced Filtering Macro takes out the existing filter

**sachins19** · 07-21-2014, 05:49 AM

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** · 07-21-2014, 06:07 AM

I've made changes as per the forum rules.

**romperstomper** · 07-21-2014, 06:15 AM

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

**sachins19** · 07-21-2014, 06:27 AM

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** · 07-21-2014, 06:34 AM

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

**sachins19** · 07-21-2014, 09:14 AM

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