I was thinking a formula like "=SUMPRODUCT(--(LEN(B7)>0))" in each row would return a 1 or 0 and we could use that to drive a collapse macro?? I dont know the first thing about macros so its really appreciated!