Staff rota help

[flier109]

I have data which looks a bit like this, for every day of the week over a period of 6 weeks. We have a bank of around 30 relief staff, so some may not work for weeks and others work most days. The abbreviations are the type of work they are rota'd to do, which are for different rates of pay and shift times. TL=Team Leader. TW=Team Worker, E=Escort etc
This data feeds into employee time sheets which are then printed off for them to correct or adjust when they work.
I need to create a summary which shows just those employees who are working each day, printed in one page. This needs to be as simple to do as possible, as it will be done by a staff member not particularly confident in excel. Ideally it would be in the order of TL, E, TW. Any ideas, anyone? Would it have to be a macro?

Employee Name Week 1 Monday Week 1 Tue etc Week 2 Monday Week 4 Wednesday

mr hobbs	TL	TW	E
Miss hobbs	TW	TW		Hol
Mr X	TW			TL
Miss X	E	TW	TW

 

[flier109]

we work 6 days, Monday through Saturday

 

[My Aswer Is This]

we work 6 days, Monday through Saturday

So your saying my script is not working?
My script looks to see if 36 cells in each row starting in Column B has some sort of data
if yes then copies row to sheet 2
6 weeks times 6 days per week equals 36

 

[flier109]

No, I'm saying I can't get it to work, it's probably something I'm, doing wrong but I'll have time to get a proper look at it without rushing later on.

thanks again for taking the time to help, much appreciated

 

[My Aswer Is This]

Workers work 6 days per week, Monday to Saturday, thanks

So then on every row if you have some data in each column from B to AK the script should copy the row to sheet2

Please explain if you have it this way and what is the script not doing.
Just saying it does not work is not helpful