This is amazing. My last step in this worksheet is to hide the rows not populated on each departments sheet. I would assume the code would be to hide any row from 3-100 if cell in column A is blank.

Is this hard to do?