How to sort & delete specific rows in a excel table

Hi All,

In continuation to my previous thread (see link below); i need to delete rows in my excel table (having 1000's of rows) with a specific condition of a column which show some energy consumption figures. The table contains many line items whose energy consumption figure is zero (o). I want to clean my file in place having sorted these zeroes? is there a fast & quick way to do it in the same file?

http://www.excelforum.com/excel-char...red-cells.html

Thanks,
Mahesh

Hi Olly,

Thanks for your earnest response. Pl see attached file for ready reference. This file already contains 2 macros. Can you explain step by step procedure as to how i could do it then for this file? Will it override my previous macros? What are pre-requisites to start with to apply the above macro which u have suggested?

Thanks,
Mahesh