Hi I am trying to shift data based on a lookup value and was wondering if there is an easy way to use vba to do so?

The first spreadsheet has student, startdate, book money per month (date as column header). Example:

student startdate 11/30/2009 12/31/2009 01/31/2010 02/28/2010 03/31/2010
1 11/30/2009 $422.37 $791.48 $485.68 $613.03 $190.78
2 12/31/2009 $804.91 $635.61 $588.87 $559.18
3 01/31/2010 $823.07 $197.35 $107.57
4 02/28/2010 $940.06 $17.80
5 03/31/2010 $90.83

The output I would like is to shift all the month left based on the startdate and just have a 'month1', 'month2', etc for each student. For example:

student Month1 Month2 Month3 Month4 Month5
1 $422.37 $791.48 $485.68 $613.03 $190.78
2 $804.91 $635.61 $588.87 $559.18
3 $823.07 $197.35 $107.57
4 $940.06 $17.80
5 $90.83


So I would need to just match each student number and their startdate and begin moving data from that month.

Any help would be great.

Thanks,