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.