Hi John

If your entries in B1:AK1 were set up as 01/01/05, 01/02/05 etc. but
formatted Format CellsNumberCustom mmm-yy

Then in B2
=A2/36
in C2
=($A$2-SUM($B$2:B2))/(37-(MONTH(C1)+12*(YEAR(C1)-YEAR($B$1))))
and copy across through D2:AK2

Obviously this does not tell the system where to start entering the values,
but deleting the formula in cells B2 and C2 would cause the 52000 to be
spread over the remaining 34 months at 1529.41 per month.

Regards

Roger Govier


John wrote:
Sorry for the breifness, let me expand: 52000 is a total payment column. I
want the divided 12 months to automatically put in the correct columns across
three years. Basically I have the total amount and want to schedule it
throughout the years.
EXAMPLE:
A B C D E F ....
Total Jan Feb Mar Apr May ....
52000 --- ---- (place divided amount begining in Mar'05
through '06)

Thanks, JOHN


"Ian" wrote:


Another thought. If your 52000 is in cell A1 type =$A$1/12 in the September
column and copy across.

--
Ian
--
"John" wrote in message
...

I have a total amount of $52,000 and I want to show an equal amount in
twelve
columns which represent 12 months from sept 2005-sept 2006. My calendar
goes
for 3 years, jan 2005- jan 2008. How do I get this amount to show up in
the
correct columns.