Delete rows based on a particular value

[booo]

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

[DonkeyOte]

see: http://www.xtremevbtalk.com/showthread.php?t=300757
(specifically post # 4)