Hi Friends

Any help will be appreciated. and thanks in advance.

I am looking for macro VBA code which I can assign to a button which
will do the following routine:

Essentially, the amounts will be recorded in column A2 onwards and the
criteria of spreading the "budget amount" (in coumns B onwards) is =<
$200 is one month, 200 to 500 is three months, 500<1000 is four
months and 1000 is 8 months.


Col A Col B Col C Col D Col E Col F Col G Col H
Amount Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov-08 Dec-08 Spread
<=200 x one month
200 < 500 x x x 3 Months
500 <1000 x x x x 4 months
1000 x x x x x x x 8 Months

Many thanks for your valuable time.

Cheers
Tony