I have 40 worksheets assigned to 40 team leaders. Each team leader has upto
40 members so might have 10 or 5... I used cell a10:a50 for member codes and
if the code reads 00 then in b10:b50 the name would appear "blank".

I would like to create another sheet with all 40 team leaders with the
members they've signed up. However, I want the "blanks" skipped and
automactically move to the next sheet/leader/member in line.

Is there a formula for that?

Regards,
**newdeas**<<