macro for populating a time sheet with values from another excel sheet

I am relatively new to Visual Basic and need little help in this problem that I am having

I have two excel sheets - one of which contains -

Start Week, Start Month, Days worked per week, Number of working weeks
eg:-
1 Jan-2009 2 12
3 Feb-2008 5 50
...
...
...

Using this I have to fill another time sheet in the same workbook which contains columns corresponding to months and weeks... so lets say -
starting from week 1 of Jan-2008 i hav to fill the next 12 columns with the value 2

I am in a kindof fix with this problem :( and have to finish off this task in the next week...It would be really gr8 if you could help me out... If required I can also send you the excel sheets...