| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
![Nick S[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
