Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete a Row IF = certain value
On linked worksheets - in Monthly Sales Reports - I can link the OPEN orders
/data from the current month to the new month - BUT if an order has been completed/shipped, how do I delete this order(which is displayed in 1 row) automatically so it does not show up in the new month. ie. All orders left open from the current month automatically go into the new month via the links - as do all the SHIPPED orders. Is it possible to STOP the SHIPPED orders from going to the new month, automatically...Thanks for any help offered! Using Excel in Office XP Pro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I delete a worksheet from my workbook | New Users to Excel | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Delete row depending on criteria | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
How to delete blank rows | Excel Discussion (Misc queries) |