jojoluv377
New Member
- Joined
- Sep 4, 2009
- Messages
- 10
So far, I have been able to create formulas to track $ by employee and total by contract; however, tracking unbilled hours (my final goal) has proven to be a challenge. The first two summaries draw the information from one worksheet; whereas, the unbilled data come from many (eventually 48 worsheets, 12 months x 4 worksheets). By the end of the year I will have 48 worksheets to draw information from. I can’t create all 48 worksheets at once because employees are added and removed every month. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
Can anyone help come up with a formula to capture the data from and give me an idea on how to modify the formula as worksheets are added to the workbook? These are the worksheets: <o></o>
- (W) Oct_2010 Range O6:O100<o></o>
- (M)T3 Sept Range V5:V30<o></o>
- (M)AXISS Range X5:X36<o></o>
- (M) Others Range V5:V30<o></o>
So far this formula works (although I did not include all the before mentioned spreadsheets)but I feel it will get unmanageable as more worksheets are added - =SUMIF('(W) Oct_2010'!C$6:C$99,A21,'(W) Oct_2010'!O23:O161)+(SUMIF('(M)T3 Sept'!E$5:E$99,A21,'(M)T3 Sept'!$V$4:$V$142))
fficeffice" /><o></o><o
> </o>Can anyone help come up with a formula to capture the data from and give me an idea on how to modify the formula as worksheets are added to the workbook? These are the worksheets: <o
></o>- (W) Oct_2010 Range O6:O100<o
></o>- (M)T3 Sept Range V5:V30<o
></o>- (M)AXISS Range X5:X36<o
></o>- (M) Others Range V5:V30<o
></o>So far this formula works (although I did not include all the before mentioned spreadsheets)but I feel it will get unmanageable as more worksheets are added - =SUMIF('(W) Oct_2010'!C$6:C$99,A21,'(W) Oct_2010'!O23:O161)+(SUMIF('(M)T3 Sept'!E$5:E$99,A21,'(M)T3 Sept'!$V$4:$V$142))
