I have a payroll list that I am trying to consolidate for ease of access. As of now there is about 1500 rows in use most of which are empty. What I would like to do is hide or unhide rows 8 - 27 based on the value of the above cell. For instance if C8 > 0 unhide row 9 else hide rows 9-27. This instance is based on the first employee the next employee rows to hide or unhide is rows 36 - 55, then the next is 64 - 83. There will always be same number of cells in between employees. I have done enough programming to assume this would use a for loop but its been so long since I've done any coding I can't remember much about it. Please advise