I have a date value in D3, and a table in B55:O89. The table looks at imported data, and pulls a count for specific criteria via vlookup, so the data changes based on the date entered into D3. I'm then using another formula to return parts of the table that have values, making the rest blank. With that being said, the count of rows with data will change based on D3. I'm thinking of adding a formula in column P that returns an invisible 0 if the table for that row is all blank, and I'm looking for some VBA code that will hide all rows with a 0 value in column P, and will re-run the script every time the date in D3 is updated or changed.