VBA auto filter

[sms2luv]

Hi Team,
I am glad that Chandoo forum has always helped me solve my excel related issues.

I have a small issue
I have Agent Names and Ids in column A&B.
The results in column C are pulled up using get pivot table formula.
I want to create a button for VBA that will auto filter agents name with blank results.

So for example if a agent budget is blank Auto filter should automatically remove agent name from the list.
File attached in reference.

▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[jindon]

I have Agent Names and Ids in column A&B.
The results in column C are pulled up using get pivot table formula.
I want to create a button for VBA that will auto filter agents name with blank results.

Formula in cell?
See if this works.

Sub test()
    On Error Resume Next
    Cells(1).CurrentRegion.Columns(3).SpecialCells(-4123, 2).EntireRow.Delete
End Sub

 

[sms2luv]

Hi, thanks for this.
I dong wantvto delete the row as it has to be used on daily basis.
What I have tried from my side, is that I made pivot of the data and selected value filter.

Please tell me if this will work