Populating Cells with Formulas Based on Adjacent Cell

I have attached a spreadsheet to help with my problem.

I am needing a macro that will populate the remainder of Column C with the 12 different formulas from C2:C13. The data in column B will vary in size i.e. just now there is data until B3, but next week there could be data until B200.

Thanks