I have a table of data with 'desk' names down the left hand side and the days of the month across the top. Each day the revenue for each desk is entered beside it's name under the column of the corresponding date. The table is 300 rows by 31 columns.
I have created a report on another tab that links to this data and I would like the rows that have no revenue values associated with them to hide automatically so the report is not so long. (only 1/2 the desks report revenue in any given month). note - some desks report negative values only
I have created a report on another tab that links to this data and I would like the rows that have no revenue values associated with them to hide automatically so the report is not so long. (only 1/2 the desks report revenue in any given month). note - some desks report negative values only