40 sheets/Formula to advance to next worksheet

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,
 
D

Don Guillett

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.
 
N

newdeas

Thanks!
It's a really large workbook so, I'll send one team worksheet with the
workseet I want the info transerred to.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top