Using VB Code to Shift Data

[savio21]

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