Delete row if value = zero

[Nick S]

I have a table of data with values in column G. There are 4800 lines of data and I want to go through and delete all rows where the value = 0.

I know this should be straight forward but I am having a brain mush day.

Any help appreciated.

Nick

[Ron de Bruin]

Hi Nick

There are a few ways

Start here
http://www.rondebruin.nl/delete.htm

If you need help post back

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Nick S" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table of data with values in column G. There are 4800 lines of
> data and I want to go through and delete all rows where the value = 0.
>
> I know this should be straight forward but I am having a brain mush
> day.
>
> Any help appreciated.
>
> Nick
>
>
> --
> Nick S
> ------------------------------------------------------------------------
> Nick S's Profile: http://www.excelforum.com/member.php...o&userid=16512
> View this thread: http://www.excelforum.com/showthread...hreadid=478784
>

[Don Guillett]

if using a macro, start from the bottom up.
or use sort or autofilter and just delete manually
--
Don Guillett
SalesAid Software
[email protected]
"Nick S" <[email protected]> wrote in
message news:[email protected]...
>
> I have a table of data with values in column G. There are 4800 lines of
> data and I want to go through and delete all rows where the value = 0.
>
> I know this should be straight forward but I am having a brain mush
> day.
>
> Any help appreciated.
>
> Nick
>
>
> --
> Nick S
> ------------------------------------------------------------------------
> Nick S's Profile:
http://www.excelforum.com/member.php...o&userid=16512
> View this thread: http://www.excelforum.com/showthread...hreadid=478784
>

[Nick S]

Thanks for your help