This is what I want to know..
cell B1 & C1 is the cell to enter the duties of two staffs (namely X & Y).
B1 is for staff X, C1 is for staff Y. staff can chose any one of duty in B1
& C1 frm a dropdownlist of 10 different duties(like "Break shift", "10 - 6
PM", "10 - 2 PM"..and so on)..

We have another cell D1 E1 & F1 where we enter the staff strength in the
shop on three intervals of time (say 10 - 2PM, 2 - 6PM, & 6 - 10PM)
Assume D1 cell to show the staffs present in the shop during time interval
10 - 2PM, E1 for 2 - 6PM & F1 for 6 - 10PM.

Now for eg, staff X chose her duty as Break Shift in cell B1(assume cell B1
as Jan 1, B2 as Jan 2 and so on), now we enter in D1 & F1 digit 1. & the
other staff chose 2 -10pm duty in C1 now the staff strenght cells are as
follows...

D1 shows 1, E1 shows 1 &F1 shows 2... This is entered manually now checking
the staff duty.. Is it possible to automate it.. When the staff's select
their duty the staff strength column in the particular day must show up the
number of staffs as per the duty automatically.. Pls help me

rgds,

--
Life isa journey not a destination