You can do it manually by applying Autofilter to the status column and
selecting "approved" from the drop-down. Then highlight all the
visible rows and click on Edit | Delete Row. Then select "All" from
the filter drop-down.

Hope this helps.

Pete

On Oct 24, 5:23*pm, destine wrote:
hi,

I am trying to come up with a code that will somehow delete an entire row if
it's content in a particular column meets the condition. *Say I want to
delete the rows whose Status column says approved.

Anybody can help?