SOMETHING CHALLENGING

[OWAIZ]

hi Guys,
i have an excel sheet. where in i have a table for the entire month coloum 1 contains, the date of the month, coloumn 2 contains sunday / monday /tuesday / etc... for the entire month... i enter the schedule for the 100 agents from coloum 3. i mark each cell as M for morning N for night H for holiday... and i do it manually... i want the off day to come in automatically at the end of the table for each agent. suppose for agent XXX i give sat / sun as H H, at the end of the table it should give me Sat Sun

is it possible.. pls guide me if possible..

thanks in advance

regards
owaiz

 

[PaddyD]

owaiz,

I get what your trying to do, but I'm not clear about how your data is set up.

Col A - dates
Col B - day names
Col C - a value from {M,N,H}

how do we know which agent these entries are associated with? where is the 'end of the table'.

Post back with more details about your table format...

Paddy

 

[OWAIZ]

Hi paddy,

thanks for ur quick reply....

the last coloum is 32 coloumn, where the dates end..

if u want more information, pls let me know

regards
owaiz

 

[applebyd]

OWAIZ,

What are you trying to schedule for?
Can you put a quick demo of the sheet up.

Either myself of Ian Mac should be able to help (There you go Ian, Volunteered!) we've done a fair bit of this stuff. Although I will say there is some VERY good freeware out there for scheduling and Excel may not be the way to go.

Hope this helps.

DaveA