LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 88
Default delete row based on value of ...

using a macro to delete a row.

how can i delete a row if the value of a cell is 0 or less...

Column A has an item number
Column B has quantities, from a negative number, 0, and positive numbers

if a cell in Column B is 0 or lower, the row will be deleted. i can delete
rows using F5, Special, Blanks, delete row..., so i am hoping for somthing
like that where i can record a macro to work with.

thank you,

jat

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Rows Based on Words Cue Excel Discussion (Misc queries) 2 June 4th 08 06:42 AM
Delete row based on cell value stantune Excel Discussion (Misc queries) 1 February 2nd 08 06:43 PM
delete row on based on cell value GKW in GA Excel Discussion (Misc queries) 1 September 18th 07 09:53 PM
How to delete a data row based on a condition wmc New Users to Excel 4 April 18th 07 02:40 PM
delete based on flow23 Excel Discussion (Misc queries) 1 July 3rd 06 12:23 PM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"