Option Explicit
 
Public Sub 指定行削除()
    Dim ws1 As Worksheet    '対象項目
    Dim ws2 As Worksheet    '対象シート
    Dim lastRow1 As Long    '対象項目   最終行
    Dim lastRow2 As Long    '対象シート 最終行
    Dim row1 As Long        '対象項目   行番号
    Dim row2 As Long        '対象シート 行番号
    Dim del_dict As Object      '削除対象のキー（種類No）
    Dim undel_dict As Object    '削除対象外のキー(種類No+名称No)
    Dim key1 As String          '種類No
    Dim key2 As String          '種類No+名称No
    Set ws1 = Worksheets("対象項目")
    Set ws2 = Worksheets("対象シート")
    Set del_dict = CreateObject("Scripting.Dictionary")
    Set undel_dict = CreateObject("Scripting.Dictionary")
    lastRow1 = ws1.Cells(Rows.count, "A").End(xlUp).Row     '対象項目の最終行取得
    lastRow2 = ws2.Cells(Rows.count, "A").End(xlUp).Row     '対象シートの最終行取得
    '対象項目を最終行まで検索
    For row1 = 3 To lastRow1
        '種類Noが空白でないなら
        If ws1.Cells(row1, "A").Value <> "" Then
            '種類Noを削除対象のキーとする
            key1 = ws1.Cells(row1, "A").Value
            del_dict(key1) = True
            '名称Noが空白でないなら、種類No+名称Noを削除対象外のキーとする
            If ws1.Cells(row1, "C").Value <> "" Then
                key2 = key1 & "|" & ws1.Cells(row1, "C").Value
                undel_dict(key2) = True
            End If
        End If
    Next
    '対象シートを最終行から2行まで処理する
    For row2 = lastRow2 To 2 Step -1
        key1 = ws2.Cells(row2, "A").Value
        key2 = key1 & "|" & ws2.Cells(row2, "C").Value
        '種類Noが削除対象となっていて
        If del_dict.exists(key1) = True Then
            '種類No+名称Noが削除対象外となっていないなら
            If undel_dict.exists(key2) = False Then
                '当該行を削除する
                ws2.Rows(row2).Delete
            End If
        End If
    Next
    MsgBox ("完了")
End Sub
 

T3B0aW9uIEV4cGxpY2l0CgpQdWJsaWMgU3ViIOaMh+WumuihjOWJiumZpCgpCiAgICBEaW0gd3MxIEFzIFdvcmtzaGVldCAgICAn5a++6LGh6aCF55uuCiAgICBEaW0gd3MyIEFzIFdvcmtzaGVldCAgICAn5a++6LGh44K344O844OICiAgICBEaW0gbGFzdFJvdzEgQXMgTG9uZyAgICAn5a++6LGh6aCF55uuICAg5pyA57WC6KGMCiAgICBEaW0gbGFzdFJvdzIgQXMgTG9uZyAgICAn5a++6LGh44K344O844OIIOacgOe1guihjAogICAgRGltIHJvdzEgQXMgTG9uZyAgICAgICAgJ+WvvuixoemgheebriAgIOihjOeVquWPtwogICAgRGltIHJvdzIgQXMgTG9uZyAgICAgICAgJ+WvvuixoeOCt+ODvOODiCDooYznlarlj7cKICAgIERpbSBkZWxfZGljdCBBcyBPYmplY3QgICAgICAn5YmK6Zmk5a++6LGh44Gu44Kt44O877yI56iu6aGeTm/vvIkKICAgIERpbSB1bmRlbF9kaWN0IEFzIE9iamVjdCAgICAn5YmK6Zmk5a++6LGh5aSW44Gu44Kt44O8KOeorumhnk5vK+WQjeensE5vKQogICAgRGltIGtleTEgQXMgU3RyaW5nICAgICAgICAgICfnqK7poZ5ObwogICAgRGltIGtleTIgQXMgU3RyaW5nICAgICAgICAgICfnqK7poZ5ObyvlkI3np7BObwogICAgU2V0IHdzMSA9IFdvcmtzaGVldHMoIuWvvuixoemgheebriIpCiAgICBTZXQgd3MyID0gV29ya3NoZWV0cygi5a++6LGh44K344O844OIIikKICAgIFNldCBkZWxfZGljdCA9IENyZWF0ZU9iamVjdCgiU2NyaXB0aW5nLkRpY3Rpb25hcnkiKQogICAgU2V0IHVuZGVsX2RpY3QgPSBDcmVhdGVPYmplY3QoIlNjcmlwdGluZy5EaWN0aW9uYXJ5IikKICAgIGxhc3RSb3cxID0gd3MxLkNlbGxzKFJvd3MuY291bnQsICJBIikuRW5kKHhsVXApLlJvdyAgICAgJ+WvvuixoemgheebruOBruacgOe1guihjOWPluW+lwogICAgbGFzdFJvdzIgPSB3czIuQ2VsbHMoUm93cy5jb3VudCwgIkEiKS5FbmQoeGxVcCkuUm93ICAgICAn5a++6LGh44K344O844OI44Gu5pyA57WC6KGM5Y+W5b6XCiAgICAn5a++6LGh6aCF55uu44KS5pyA57WC6KGM44G+44Gn5qSc57SiCiAgICBGb3Igcm93MSA9IDMgVG8gbGFzdFJvdzEKICAgICAgICAn56iu6aGeTm/jgYznqbrnmb3jgafjgarjgYTjgarjgokKICAgICAgICBJZiB3czEuQ2VsbHMocm93MSwgIkEiKS5WYWx1ZSA8PiAiIiBUaGVuCiAgICAgICAgICAgICfnqK7poZ5Ob+OCkuWJiumZpOWvvuixoeOBruOCreODvOOBqOOBmeOCiwogICAgICAgICAgICBrZXkxID0gd3MxLkNlbGxzKHJvdzEsICJBIikuVmFsdWUKICAgICAgICAgICAgZGVsX2RpY3Qoa2V5MSkgPSBUcnVlCiAgICAgICAgICAgICflkI3np7BOb+OBjOepuueZveOBp+OBquOBhOOBquOCieOAgeeorumhnk5vK+WQjeensE5v44KS5YmK6Zmk5a++6LGh5aSW44Gu44Kt44O844Go44GZ44KLCiAgICAgICAgICAgIElmIHdzMS5DZWxscyhyb3cxLCAiQyIpLlZhbHVlIDw+ICIiIFRoZW4KICAgICAgICAgICAgICAgIGtleTIgPSBrZXkxICYgInwiICYgd3MxLkNlbGxzKHJvdzEsICJDIikuVmFsdWUKICAgICAgICAgICAgICAgIHVuZGVsX2RpY3Qoa2V5MikgPSBUcnVlCiAgICAgICAgICAgIEVuZCBJZgogICAgICAgIEVuZCBJZgogICAgTmV4dAogICAgJ+WvvuixoeOCt+ODvOODiOOCkuacgOe1guihjOOBi+OCiTLooYzjgb7jgaflh6bnkIbjgZnjgosKICAgIEZvciByb3cyID0gbGFzdFJvdzIgVG8gMiBTdGVwIC0xCiAgICAgICAga2V5MSA9IHdzMi5DZWxscyhyb3cyLCAiQSIpLlZhbHVlCiAgICAgICAga2V5MiA9IGtleTEgJiAifCIgJiB3czIuQ2VsbHMocm93MiwgIkMiKS5WYWx1ZQogICAgICAgICfnqK7poZ5Ob+OBjOWJiumZpOWvvuixoeOBqOOBquOBo+OBpuOBhOOBpgogICAgICAgIElmIGRlbF9kaWN0LmV4aXN0cyhrZXkxKSA9IFRydWUgVGhlbgogICAgICAgICAgICAn56iu6aGeTm8r5ZCN56ewTm/jgYzliYrpmaTlr77osaHlpJbjgajjgarjgaPjgabjgYTjgarjgYTjgarjgokKICAgICAgICAgICAgSWYgdW5kZWxfZGljdC5leGlzdHMoa2V5MikgPSBGYWxzZSBUaGVuCiAgICAgICAgICAgICAgICAn5b2T6Kmy6KGM44KS5YmK6Zmk44GZ44KLCiAgICAgICAgICAgICAgICB3czIuUm93cyhyb3cyKS5EZWxldGUKICAgICAgICAgICAgRW5kIElmCiAgICAgICAgRW5kIElmCiAgICBOZXh0CiAgICBNc2dCb3ggKCLlrozkuoYiKQpFbmQgU3ViCg==