T
Tia
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
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