Remove Row based on criteria

[SimondsJM]

I have a sheet with data on it that sometimes needs to be removed.

What I have is a form that you can select the item in column B to be removed but i also need data in column C to be removed below that.


---------------------
Column B|Column C|
Data in B| No Data|
No Data | Data 1
No Data | Data 2
No Data | Data 3
---------------------
New Data| No Data
No Data | Data 4
No Data | Data 5

So If I select "Data in B" from my combobox on the form I want all coresponding data (Data 1-5) to be removed as well. The areas labeled No Data are blank.

Any help is greatly appreciated.