R
ritpg
I've got the following Excel sheet in which the work figures represent
the weekly and cumulative hours in a person's hours budget:
05-Jan-09 12-Jan-09 19-Jan-09
etc.
Joe Smith
Work 40 40 35
Cumulative Work 40 80 115
Mary Jones
Work 25 40 35
Cumulative Work 25 65 100
John Jefferson
Work 35 40 35
Cumulative Work 35 75 110
etc.
And I have a 2nd sheet as follows:
Current Date: 12-Jan-09
Cumulative Hours
Budgeted to Date
Mary Jones 65
Joe Smith 80
John Jefferson 75
etc.
Note that the names on the 2nd sheet are not in the same order as the
1st sheet. I want to be able to change the Current Date on the 2nd
sheet and have the Cumulative Hours Budgeted to Date column populated
automatically.
I know there are folks out there much smarter about Excel than I. Any
and all inputs will be greatly appreciated.
Thanks,
Terry
the weekly and cumulative hours in a person's hours budget:
05-Jan-09 12-Jan-09 19-Jan-09
etc.
Joe Smith
Work 40 40 35
Cumulative Work 40 80 115
Mary Jones
Work 25 40 35
Cumulative Work 25 65 100
John Jefferson
Work 35 40 35
Cumulative Work 35 75 110
etc.
And I have a 2nd sheet as follows:
Current Date: 12-Jan-09
Cumulative Hours
Budgeted to Date
Mary Jones 65
Joe Smith 80
John Jefferson 75
etc.
Note that the names on the 2nd sheet are not in the same order as the
1st sheet. I want to be able to change the Current Date on the 2nd
sheet and have the Cumulative Hours Budgeted to Date column populated
automatically.
I know there are folks out there much smarter about Excel than I. Any
and all inputs will be greatly appreciated.
Thanks,
Terry