Excel advanced filter - blank and zero values

[Mallesh23]

Hi Team,

Need your help on advaneced filter.

DSR YTD MAY 2020.xlsx
	A	B	C	D	E	F
1	Set1				Set2
2	Month	Region			Company	Amount
3	MAY*	South			ABC Limited*	<>0
4	MAY*	North			ABC Limited*	blank
5	MAY*	East
6	MAY*	West
7
8
9	Combine all combination
10	Month	Region	Company	Amount
11	MAY*	South	ABC Limited*	<>0
12	MAY*	North	ABC Limited*	blank
13	MAY*	East
14	MAY*	West
Sheet1

1) I want May month Data,
2) In Region I want North,South,East,West Data
3) I want all Company Data Irrespective amount Column ,
Except if Company is abc Limited* I dont like to Include 0 value and blank cells{. Negative/Positive Notional is ok.)


How to apply advanced filter for Company header and Amount Column. below is recorded code.

With Range("a1").CurrentRegion
        AutoFilter Field:=1, Criteria1:="=ABC*", Operator:=xlAnd
        .AutoFilter Field:=2, Criteria1:="=0", Operator:=xlOr, Criteria2:="="
         If .Columns(1).SpecialCells(xlCellTypeVisible).Count > 1 Then
            .Offset(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
            Sheet2.Cells.AutoFilter
        Else
            Sheet2.Cells.AutoFilter
        End If

Can we club all scenarios in advanced filter. I am only able to apply advanced filter for month and Region.

Thanks
mg