Thread: Delete rows based on a particular value

I am trying to delete rows based on one of the values for a particular data element. To be more clear, I have attached a spreadsheet with sample data. In the spreadsheet, i need a macro to delete rows containing the value "L" for designation and keep the remaining data. Kindly help me out on this.

Thanks