Delete row if value = zero
 

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

Delete row if value = zero
 

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" wrote in message
...

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

Delete row if value = zero
 

if using a macro, start from the bottom up.
or use sort or autofilter and just delete manually
--
Don Guillett
SalesAid Software

"Nick S" wrote in
message ...

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

Delete row if value = zero
 

Thanks for your hel

--
Nick
-----------------------------------------------------------------------
Nick S's Profile: http://www.excelforum.com/member.php...fo&userid=1651
View this thread: http://www.excelforum.com/showthread.php?threadid=47878