John, that's almost right on except is it possible for column D to show what
is to make up the 1,000?

example would be that i have 999 left over from 3/15 so on 3/16 i'd start
out with 999 in column C and column D should show that i need 1 from 3/16 to
equal 1,000

thanks

"John" wrote:

Hi Bowmanator
I've attached a link to a sample file. Download it and check if that's what you
want.
http://cjoint.com/?dprqqVSBia
Take note of its limitation.
HTH
John
"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

.