| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows based on criteria
I am in the process of doing end of year financial reporting analysis
and I want to be able to run a macro that hides empty rows based on a specific criteria. Column C lists the accounts codes, column G is the YTD Actuals and column H is the YTD Budget. What I want to do, is..... If there is a value in a row in Column C and if the value of the cell in both column G & H is 0 the hide the row. If anyone can point me in the right direction to research this further would be sincerely appreciated. PS: I am using MS Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to show/hide rows based on a range of dates | Excel Programming | |||
| Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
| Macro to hide and unhide based on criteria | Excel Discussion (Misc queries) | |||
| Macro to hide rows based on a zero value in a particular cell | Excel Programming | |||
| macro to hide rows based on formula? | Excel Programming | |||
Threaded Mode
