What is the sequence of events? You say you want to automate this. What
comes first? Detail what you enter and then what you want Excel to do (the
automate part). Then what happens next? The next date row maybe?
In short, Excel is dumb and it needs to know what is the trigger to make it
automate something. Maybe any entry in Column B? It might help if you
provide the series of steps you must do when you do this manually. Remember
that you are talking to people who know nothing about what you have or want
to have. HTH Otto

"Bowmanator" wrote in message
...
i'm working on a shipping log that i do now by hand and would like to
automate if possible. every load equals 1,000 and alot of the loads are
split
loads.

a b c d e
1 date amount previous current total
2 3/10 2053 1000
3 1000
4 53
5 3/11 1019 53 947 1000
6 72
7 3/12 3000 72 928 1000
8 1000
9 1000
10 72

in this example it shows what i need to equal 1,000 and if there's over
1,000 left of that run i'd like the next line to show 1,000 and so on
until i
can't make a full load of 1,000.

hope this sounds right
thanks