M
Momof2
I have a pivot table which shows Employees (Column A), all months from 07 -
08 (Column B) and a total of each month of missing receipts (Column C). I
have a conditional formating set to highlight column B and C if column C has
a value in it. What I'm trying to do now is to have the rows with no values
in column C automatically be hidden. Any ideas?
Ex:
Name Mnth Total
Doe, John 07 Jan
07 Feb 1
07 Mar
08 (Column B) and a total of each month of missing receipts (Column C). I
have a conditional formating set to highlight column B and C if column C has
a value in it. What I'm trying to do now is to have the rows with no values
in column C automatically be hidden. Any ideas?
Ex:
Name Mnth Total
Doe, John 07 Jan
07 Feb 1
07 Mar