Update data depending on date using VB

[studentt]

Hello !

A date is entered by user in Cell A1(Sheet1). Some calculations should happen in sheet2 based on the date entered.


If in Sheet1, A1 = Dates are between 01/04/2012 - 01/09/2012, then in Sheet 2
C2:C19(18 rows) should have value = 0%, C20:C25(6 rows) should be value 8%, C26:C31(6 rows) 5% ,C32:C37(6 rows) 2.5% , C38:C43(6 rows) 0.83%

If in Sheet1, A1 = Dates are between 01/10/2012 - 01/03/2013, then in Sheet 2
C2:C19(24 rows) should have value = 0%, C20:C25(6 rows) should be value 8.33%, C26:C31(6 rows) 5% ,C32:C37(6 rows) 2.5% , C38:C43(6 rows) 0.83%


If in Sheet1, A1 = Dates are between 01/14/2013 - 01/09/2013, then in Sheet 2
C2:C19(30 rows) should have value = 0%, C20:C25(6 rows) should be value 8.33%, C26:C31(6 rows) 5% ,C32:C37(6 rows) 2.5% , C38:C43(6 rows) 0.83%


If in Sheet1, A1 = Dates are between 01/10/2013 - 01/03/2014, then in Sheet 2
C2:C19(36 rows) should have value = 0%, C20:C25(6 rows) should be value 8.33%, C26:C31(6 rows) 5% ,C32:C37(6 rows) 2.5% , C38:C43(6 rows) 0.83%

And so on . . . .

i.e. Only 0 is increasing after each 6 months by 6 more rows.