| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
queary on how to disable rows with empty values
Hi,
In my excel workbook, I am having a dashboard which has a row called area. I have regions under the area. the data for this is comming from pivot table in another sheet say sheet 2. Suppose there are two regions say X and Y under area. now, if in the pivot table in sheet 2 if we are selectin only x then in the dashboard its showing values for X but the next row its showing 0 in all cells. I dont want that. I want only the rows with values to be displayed. How can i achieve this? any help.. Thanks in advance, Best Regards, Azhar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Formula Queary | Excel Discussion (Misc queries) | |||
| adding rows, pasting values then empty sheet | Excel Worksheet Functions | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Delete Rows with Empty Cells with empty column 1 | Excel Programming | |||
| Disable Printing If Cell Empty | Excel Programming | |||
Threaded Mode
