Eliminating rows with 0 in Column D

[BHammy]

Hello!

I have a sheet with 5 Columns. Another row that has a 0 in Column D, I want removed. For example if the columns initially look like this:

A B C D E
1 908 11/12/2012 0 m
2 606 12/17/2012 0 q
3 524 1/28/2013 400 r
4 221 2/11/2013 0 w
5 106 3/11/2013 0 b
6 026 4/15/2013 400 03
7 05 5/13/2013 0 377
8 05400 6/17/2013 400 h

I want it to look like this:


A B C D E

3 524 1/28/2013 400 r
6 026 4/15/2013 400 03
8 05400 6/17/2013 400 h

This is a several thousand line sheet, so I need a shortcut to do it, not manually deleting many rows.

Thanks!

[oeldere]

Try this macro, on a copy of your workbook.

Please Login or Register  to view this content.

[BHammy]

This is awesome! Thank you very much!

[oeldere]

Glad i could help.

Thanks for the feed back