Hi guys,
I'm trying to create a worksheet to track and forecast work done for upcoming week.
The sheet is set up to have several groups in which individual tasks below are summed up to produce a total. This is supposed to span weekly across 3 months. Therefore, for the following week when the user inputs a new beginning week. It deletes the first column and shifts the data over leaving only the final column to filled out by the user.
For ex:
Beginning Date: February 19, 2011
Project Name | Task Name | Week Feb 19 | Week Feb 26 | so on (these are just headers)
Project 1 | (blank) | Total of tasks for Feb 19| Total of tasks for Feb 26
(blank) | Task 1 | Hours for task
(blank) | Task 2 | Hours for task
Project 2| (blank) | So on
Therefore, for the next week it should delete the previous 1st week and shift all the data over by 1 column while maintaing the formulas and data.
Result Expected:
Beginning Date: February 26, 20111
Project Name | Task Name | Week Feb 26 | Week Mar 5
and so on...
If a spreadsheet is necessary I'll try to upload on. Also, a note that the headers are in a formula linked to the beginning date. If a clickable button is require I'm all game, however if it can just notice that the date has changed and automatically update that is good enough too.
Thanks in advance
Bookmarks