Staff rota Excel 2010

Hello Forum,

I have developed a staff rota for my department. The spreadsheet automatically works out shift times minus lunch breaks and subtracts this from contracted hours. Hours of differing times to cover most possibilities are selected from drop down lists as shown in the attachment under John.
For instance the attached shows Bob has taken 37.5 hours AL so therefore Hours Left equates to 0.
Second line down Sue is rostered 08:30 to 16:30, this equates to a 7.5 hour day and the time is accordingly subtracted from contracted hours.

What I would like to add and am having trouble with is when 'AL 37.5' is selected for the Monday, the rest of the days for that week automatically show 'AL'. I think this would be a nice addition to the workbook.

Any assistance greatly received and appreciated.

Howard