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.

[studentt]

Hi !

https://www.box.com/s/1641928f0eba6d6c58b9

Start date : 01.04.2012(First April 2012)
End date : 01.09.2030(30 Sep 2030)

The table(Columns G-J) is not supposed to be there. It is actually the result of column C of how it would look like depending on the date entered in A1. I have uploaded a final version. It has a table in green. That is the source(f2-f9). Data would be picked up from it and arranged in column C. The green table could be changed in future and then the column C should also follow this change.
Example : If the date enetered in A1 is between 01.04.2012-01.09.2012, then column C looks like Column G
If the date enetered in A1 is between 01.10.2012-01.03.2013, then column C looks like Column H
If the date enetered in A1 is between 01.04.2013-01.09.2013, then column C looks like Column I (and so on till 01.09.2030)

Dates entered in A1(Sheet1) will always be first day of any month(User enters by keyboard).

[studentt]

Hi !

https://www.box.com/s/1641928f0eba6d6c58b9

Start date : 01.04.2012(First April 2012)
End date : 01.09.2030(30 Sep 2030)

The table(Columns G-J) is not supposed to be there. It is actually the result of column C of how it would look like depending on the date entered in A1. I have uploaded a final version. It has a table in green. That is the source(f2-f9). Data would be picked up from it and arranged in column C. The green table could be changed in future and then the column C should also follow this change.
Example : If the date enetered in A1 is between 01.04.2012-01.09.2012, then column C looks like Column G
If the date enetered in A1 is between 01.10.2012-01.03.2013, then column C looks like Column H
If the date enetered in A1 is between 01.04.2013-01.09.2013, then column C looks like Column I (and so on till 01.09.2030)

Dates entered in A1(Sheet1) will always be first day of any month(User enters by keyboard).

[studentt]

Any ideas ?

[studentt]

need help here