There is no way, unfortunately, to easily hide rows based on the value of a particular cell in a row.
You can, however, achieve the same effect by using a macro to analyze the cell and adjust row height accordingly.
I’ve posted several examples of manipulating pivot tables with VBA, for example, Dynamic Chart using Pivot Table and VBA and Update Regular Chart when Pivot Table Updates.
These examples included specific procedures, and the emphasis was on the results of the manipulation.
For example, if you have three worksheets ("Sheet1", "Sheet2", and "Sheet3") in a workbook ("My Workbook"), you can reference "Sheet2" with either Whenever you can, declare values as constants, rather than variables.
Since their values never change, they are evaluated only once when your code is compiled, rather than each time they are used at run time.
He is president of Sharon Parq Associates, a computer and publishing services company. Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results.
Order-Matic: Order and Inventory Management in Excel will enable you to add your orders and instantly see if the stock exists to cover the order.
It is designed for training purposes but could be modified to suit your individual needs.
This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables.
I have had requests for an application like this when I released the Invoice Generator.