Hi

I made an annual leave workbook  for all employee each one has his own
sheet with his own records and total

Ex : From=A2         TO=B2             C2= Total
      01/01/2008       02/01/2008       2 DAYS
      01/02/2008       05/02/2008       6 DAYS

I made a sheet for all employees and i created a sheet called summary
that will allow me to know the total of days in each month
Ex:

A2=Name       B2= 01/08          C2=02/08              D2=03/08
ETC
A3Tia             B3  2 days          C3 6 days             D3   0
A4 John         B4     0
0                            0

What i need to do is to copy the total FROM THE WIDTH AND BE ABLE TO
PAST IT IN THE COLUMS

EX: COPY (C3:C40) AND PASTE IT IN (B3 TILL D3)

HOPE U UNDERSTOOD IT GUYS

Please help