Need VBA Code delete Particular value in Particular table dashboard

Hi breadwinner,
This code will do most of what you need but the bottom summary rows must be deleted manually. See if you can work with this.

Please Login or Register  to view this content.

Yo, Hey,

I thought you might change which rows you wanted to delete so replace my InputBox with some code and do it another way.
You could pass the "words to look for" in a parameter in the Sub, but I didn't know if you could figure that out.

Could you be more exact with a description of

Vertical only one rest of table end with suffix words leave them.

I'm clueless on what you mean or want...

I think this is what it does..

I guess I still don't understand what you want.

According to the initial post a VBA demonstration as a beginner starter to paste only to the Dashboard worksheet module :

PHP Code: 

Sub Demo1()
           Dim Rf As Range, F&, V
    With UsedRange.Columns(1)
           Set Rf = .Find("JAPAC Recong - *", , , 1)
        If Not Rf Is Nothing Then
           F = Rf.Row
        Do
           V = Application.Match("VTT_Group Business Vertical", Rf.CurrentRegion.Columns(1), 0)
           If IsNumeric(V) Then Rf(V).EntireRow.Delete
           Set Rf = .FindNext(Rf)
        Loop While Rf.Row > F
           Set Rf = Nothing
        End If
    End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄