N
newdeas
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,
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,