| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
hiding a row in a spreadsheet if calculated value = 0
Hello,
I am working on invoices for my employer. Each row in the spreadsheet has a calculated value. When the calculated value in the row = 0, then I am to 'hide' the row. If the calculated value is not =0, (could be positive or negative), then I am to display or 'unhide' the row. Does anyone know how to do this? Macros and VBA responses are ok. :) -- Thank you, Electricbluelady |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding files in the same spreadsheet | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Calculated Link to Another Spreadsheet | Excel Discussion (Misc queries) | |||
| User form and hiding spreadsheet | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
Threaded Mode
