Sounds like a loop
for each ws in worsheets
ws.dothis
next ws

However, you need to decide what it will look like. Describe fully or, if
desired, send your wb to me at the address below.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"newdeas" wrote in message
...
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**<<