| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Macro to hide rows that have a "0" quantity value
Hi all and thanks for any help at all.
Basically Im creating a full list of all the parts we carry in our company. Every single part(row) will start off with a quantity of 0 and have the description next to it etc. If I put a quantity greater than 0 in the row for that part, I want to be able to push cntrl+C to hide all the rows(parts) that are 0 quantity and only show the rows that have quantity greater than 0. Then if I want to see everything again that has the 0 quantity, to push cntrl+B. Thanks for any help! Sincerely Neil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically hide "FALSE" rows? | Excel Discussion (Misc queries) | |||
| If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches | Excel Discussion (Misc queries) | |||
| How do I build "hide a row" into a macro if #N/A appears in a colu | Excel Programming | |||
| If "x" Hide / Unhide Rows | Excel Discussion (Misc queries) | |||
| How do you hide macro names from showing in "Tools"? | Excel Programming | |||
Threaded Mode
