Advanced Filtering Macro takes out the existing filter

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

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

Sub FilterERT()
'
' FilterERT Macro
'

'
    Range("C63:G63").Select
    Range("B34:DN58").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
        Range("C62:G63"), Unique:=False
    Range("C34:G34").Select
    ActiveWindow.ScrollRow = 29
    ActiveWindow.ScrollRow = 28
End Sub

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

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

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

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

Perfect. This solves my query. Thanks!!

I've made changes as per the forum rules.