k_v_deepu
09-17-2008, 03:21 AM
Hi,
I have a excel workbook which has detail of capacity planning on a weekly basis, each week has 2 worksheets (Ex: "Weekly 1Sep-5Sep" & "Weekly Indv 1Sep-5Sep"
In "Weekly Indv 1Sep-5Sep" sheet i update individuals daily workload in hours and i calculate the total for the week in "Weekly 1Sep-5Sep" sheet by the formula
=SUM('Weekly Indv 1Sep-5Sep'!C4+'Weekly Indv 1Sep-5Sep'!M4+'Weekly Indv 1Sep-5Sep'!W4+'Weekly Indv 1Sep-5Sep'!AG4+'Weekly Indv 1Sep-5Sep'!AQ4+'Weekly Indv 1Sep-5Sep'!BA4+'Weekly Indv 1Sep-5Sep'!BK4+'Weekly Indv 1Sep-5Sep'!BU4+'Weekly Indv 1Sep-5Sep'!CE4+'Weekly Indv 1Sep-5Sep'!CO4+'Weekly Indv 1Sep-5Sep'!CY4)
now i have a new recruitee in my team so i have edit the above formula
and add the new recruitees time also, the formula should be like below
=SUM('Weekly Indv 1Sep-5Sep'!C4+'Weekly Indv 1Sep-5Sep'!M4+'Weekly Indv 1Sep-5Sep'!W4+'Weekly Indv 1Sep-5Sep'!AG4+'Weekly Indv 1Sep-5Sep'!AQ4+'Weekly Indv 1Sep-5Sep'!BA4+'Weekly Indv 1Sep-5Sep'!BK4+'Weekly Indv 1Sep-5Sep'!BU4+'Weekly Indv 1Sep-5Sep'!CE4+'Weekly Indv 1Sep-5Sep'!CO4+'Weekly Indv 1Sep-5Sep'!CY4+'Weekly Indv 1Sep-5Sep'!DI4)
i have sheets upto december of this year on a weekly basis
can anyone suggest me a code to alter the formula in each "B4" cell of each Weekly sheet
thanks in advance
I have a excel workbook which has detail of capacity planning on a weekly basis, each week has 2 worksheets (Ex: "Weekly 1Sep-5Sep" & "Weekly Indv 1Sep-5Sep"
In "Weekly Indv 1Sep-5Sep" sheet i update individuals daily workload in hours and i calculate the total for the week in "Weekly 1Sep-5Sep" sheet by the formula
=SUM('Weekly Indv 1Sep-5Sep'!C4+'Weekly Indv 1Sep-5Sep'!M4+'Weekly Indv 1Sep-5Sep'!W4+'Weekly Indv 1Sep-5Sep'!AG4+'Weekly Indv 1Sep-5Sep'!AQ4+'Weekly Indv 1Sep-5Sep'!BA4+'Weekly Indv 1Sep-5Sep'!BK4+'Weekly Indv 1Sep-5Sep'!BU4+'Weekly Indv 1Sep-5Sep'!CE4+'Weekly Indv 1Sep-5Sep'!CO4+'Weekly Indv 1Sep-5Sep'!CY4)
now i have a new recruitee in my team so i have edit the above formula
and add the new recruitees time also, the formula should be like below
=SUM('Weekly Indv 1Sep-5Sep'!C4+'Weekly Indv 1Sep-5Sep'!M4+'Weekly Indv 1Sep-5Sep'!W4+'Weekly Indv 1Sep-5Sep'!AG4+'Weekly Indv 1Sep-5Sep'!AQ4+'Weekly Indv 1Sep-5Sep'!BA4+'Weekly Indv 1Sep-5Sep'!BK4+'Weekly Indv 1Sep-5Sep'!BU4+'Weekly Indv 1Sep-5Sep'!CE4+'Weekly Indv 1Sep-5Sep'!CO4+'Weekly Indv 1Sep-5Sep'!CY4+'Weekly Indv 1Sep-5Sep'!DI4)
i have sheets upto december of this year on a weekly basis
can anyone suggest me a code to alter the formula in each "B4" cell of each Weekly sheet
thanks in advance