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

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

"Otto Moehrbach" wrote:

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

.
what i'm doing here is trying to keep track of how many full truck loads i can ship before i run out of product that was ran on a certain day. then the next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads of that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal 1000. then it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks

what i'm doing here is trying to keep track of how many full truck loads i
can ship before i run out of product that was ran on a certain day. then the
next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads of that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal 1000. then it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks
"Otto Moehrbach" wrote:

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

.

Excel 2007, Table
http://www.mediafire.com/file/ymlkj5izyny/03_14_10.xlsx
Pdf preview:
http://www.mediafire.com/file/znmwdmlmmmy/03_14_10.pdf

You didn't say anything about what Excel should/could use as the trigger to
fire the automation. For now I'll assume it's any numerical entry made in
Column B below row 1. Excel can do lots for you with this but it must be
told every little detail so I have a question.
Question: Is every entry in Column B ALWAYS 1000 or greater? If not, and
the sum of that entry and the "leftover" (53 in your 3/10 example) is less
than 1000, what do you want to happen?
Another question: What version of Excel are you using? Otto

"Bowmanator" wrote in message
...

what i'm doing here is trying to keep track of how many full truck loads i
can ship before i run out of product that was ran on a certain day. then
the
next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads of that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal 1000. then
it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks
"Otto Moehrbach" wrote:

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

.

you assumed everything correct, and everything entered in b2 and below will
be greater then 1,000.

"Otto Moehrbach" wrote:

You didn't say anything about what Excel should/could use as the trigger to
fire the automation. For now I'll assume it's any numerical entry made in
Column B below row 1. Excel can do lots for you with this but it must be
told every little detail so I have a question.
Question: Is every entry in Column B ALWAYS 1000 or greater? If not, and
the sum of that entry and the "leftover" (53 in your 3/10 example) is less
than 1000, what do you want to happen?
Another question: What version of Excel are you using? Otto

"Bowmanator" wrote in message
...

what i'm doing here is trying to keep track of how many full truck loads i
can ship before i run out of product that was ran on a certain day. then
the
next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads of that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal 1000. then
it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks
"Otto Moehrbach" wrote:

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

.

.

forgot, i'm using office xp pro

"Bowmanator" wrote:

you assumed everything correct, and everything entered in b2 and below will
be greater then 1,000.

"Otto Moehrbach" wrote:

You didn't say anything about what Excel should/could use as the trigger to
fire the automation. For now I'll assume it's any numerical entry made in
Column B below row 1. Excel can do lots for you with this but it must be
told every little detail so I have a question.
Question: Is every entry in Column B ALWAYS 1000 or greater? If not, and
the sum of that entry and the "leftover" (53 in your 3/10 example) is less
than 1000, what do you want to happen?
Another question: What version of Excel are you using? Otto

"Bowmanator" wrote in message
...

what i'm doing here is trying to keep track of how many full truck loads i
can ship before i run out of product that was ran on a certain day. then
the
next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads of that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal 1000. then
it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks
"Otto Moehrbach" wrote:

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

.

.

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

The macros below do what you want. The first macro is an event macro that
fires whenever an entry is made in Column B. This macro must be placed in
the sheet module of your sheet. To access that module, right-click on the
sheet tab and select View Code. Paste this first macro into that module,
"X" out of the module to return to your sheet. The other 2 macros including
everything from "Option Explicit" and below should be placed in a regular
module. Come back if you need more. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
If Target.Column = 2 Then
If Target.Row = 2 Then _
Call FirstEntry(Target)
If Target.Row 2 Then _
Call TheRestEntry(Target)
End If
End Sub

Option Explicit
Dim c As Long
Dim WhatsLeft As Long

Sub FirstEntry(TheCell As Range)
Dim cc As Long
Application.EnableEvents = False
cc = Int(TheCell / 1000)
For c = 0 To cc - 1
TheCell.Offset(c, 3) = 1000
Next c
WhatsLeft = TheCell.Value - cc * 1000
TheCell.Offset(cc, 3) = WhatsLeft
Application.EnableEvents = True
End Sub

Sub TheRestEntry(TheCell As Range)
Application.EnableEvents = False
TheCell.Offset(, 1) = TheCell.Offset(-1, 3)
TheCell.Offset(, 2) = 1000 - TheCell.Offset(, 1)
TheCell.Offset(, 3) = 1000
WhatsLeft = TheCell - TheCell.Offset(, 2)
For c = 1 To 100
If WhatsLeft = 1000 Then
TheCell.Offset(c, 3) = 1000
WhatsLeft = WhatsLeft - 1000
Else
TheCell.Offset(c, 3) = WhatsLeft
Exit For
End If
Next c
Application.EnableEvents = True
End Sub


"Bowmanator" wrote in message
...
forgot, i'm using office xp pro

"Bowmanator" wrote:

you assumed everything correct, and everything entered in b2 and below
will
be greater then 1,000.

"Otto Moehrbach" wrote:

You didn't say anything about what Excel should/could use as the
trigger to
fire the automation. For now I'll assume it's any numerical entry made
in
Column B below row 1. Excel can do lots for you with this but it must
be
told every little detail so I have a question.
Question: Is every entry in Column B ALWAYS 1000 or greater? If not,
and
the sum of that entry and the "leftover" (53 in your 3/10 example) is
less
than 1000, what do you want to happen?
Another question: What version of Excel are you using? Otto

"Bowmanator" wrote in message
...

what i'm doing here is trying to keep track of how many full truck
loads i
can ship before i run out of product that was ran on a certain day.
then
the
next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads of
that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll
need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal 1000.
then
it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks
"Otto Moehrbach" wrote:

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

.

.

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

.

Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0 value in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0 value in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.

John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will transfer down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0 value in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.

Hi
You're right, a "bug", the formula I used in column C is no good for this
application.
I need to rethink this over, don't know if I've got time today.
Did you look the macro that Otto Moehrbach sent you, it works very well from
what I can see.
Anyway, I will have a look and see if I can correct the problem. It's the "MIN()
formula in the other cells that is giving me the problem,
I may need to rethink and start new.
Will post back.
Regards
John


"Bowmanator" wrote in message
...
John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will transfer down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0 value
in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.

yes but never applied a marco before so i'm trying to read up on it

"John" wrote:

Hi
You're right, a "bug", the formula I used in column C is no good for this
application.
I need to rethink this over, don't know if I've got time today.
Did you look the macro that Otto Moehrbach sent you, it works very well from
what I can see.
Anyway, I will have a look and see if I can correct the problem. It's the "MIN()
formula in the other cells that is giving me the problem,
I may need to rethink and start new.
Will post back.
Regards
John


"Bowmanator" wrote in message
...
John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will transfer down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0 value
in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.


.

Ask questions. If you are still unsure of what to do with the macros, you
can send me an email and I'll send you the file I generated for this. It
will have all the macros properly placed. My email is
. Remove the "extra" from this email address.
Otto

"Bowmanator" wrote in message
...
yes but never applied a marco before so i'm trying to read up on it

"John" wrote:

Hi
You're right, a "bug", the formula I used in column C is no good for this
application.
I need to rethink this over, don't know if I've got time today.
Did you look the macro that Otto Moehrbach sent you, it works very well
from
what I can see.
Anyway, I will have a look and see if I can correct the problem. It's the
"MIN()
formula in the other cells that is giving me the problem,
I may need to rethink and start new.
Will post back.
Regards
John


"Bowmanator" wrote in message
...
John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will
transfer down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0
value
in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.


.

Otto,

i figured out how to insert and run the marcos and it works great but i have
a couple questions for you.

1. what would i need to change in the marcos if i wanted to add more columns?

what it will look like is this
A B C D E F
1 date lot# amount previous crrent total


2. there is a possability that the amount would be less then 1000
is there something i can change? learning is great but tuff.

thanks


"Otto Moehrbach" wrote:

The macros below do what you want. The first macro is an event macro that
fires whenever an entry is made in Column B. This macro must be placed in
the sheet module of your sheet. To access that module, right-click on the
sheet tab and select View Code. Paste this first macro into that module,
"X" out of the module to return to your sheet. The other 2 macros including
everything from "Option Explicit" and below should be placed in a regular
module. Come back if you need more. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
If Target.Column = 2 Then
If Target.Row = 2 Then _
Call FirstEntry(Target)
If Target.Row 2 Then _
Call TheRestEntry(Target)
End If
End Sub

Option Explicit
Dim c As Long
Dim WhatsLeft As Long

Sub FirstEntry(TheCell As Range)
Dim cc As Long
Application.EnableEvents = False
cc = Int(TheCell / 1000)
For c = 0 To cc - 1
TheCell.Offset(c, 3) = 1000
Next c
WhatsLeft = TheCell.Value - cc * 1000
TheCell.Offset(cc, 3) = WhatsLeft
Application.EnableEvents = True
End Sub

Sub TheRestEntry(TheCell As Range)
Application.EnableEvents = False
TheCell.Offset(, 1) = TheCell.Offset(-1, 3)
TheCell.Offset(, 2) = 1000 - TheCell.Offset(, 1)
TheCell.Offset(, 3) = 1000
WhatsLeft = TheCell - TheCell.Offset(, 2)
For c = 1 To 100
If WhatsLeft = 1000 Then
TheCell.Offset(c, 3) = 1000
WhatsLeft = WhatsLeft - 1000
Else
TheCell.Offset(c, 3) = WhatsLeft
Exit For
End If
Next c
Application.EnableEvents = True
End Sub


"Bowmanator" wrote in message
...
forgot, i'm using office xp pro

"Bowmanator" wrote:

you assumed everything correct, and everything entered in b2 and below
will
be greater then 1,000.

"Otto Moehrbach" wrote:

You didn't say anything about what Excel should/could use as the
trigger to
fire the automation. For now I'll assume it's any numerical entry made
in
Column B below row 1. Excel can do lots for you with this but it must
be
told every little detail so I have a question.
Question: Is every entry in Column B ALWAYS 1000 or greater? If not,
and
the sum of that entry and the "leftover" (53 in your 3/10 example) is
less
than 1000, what do you want to happen?
Another question: What version of Excel are you using? Otto

"Bowmanator" wrote in message
...

what i'm doing here is trying to keep track of how many full truck
loads i
can ship before i run out of product that was ran on a certain day.
then
the
next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads of
that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll
need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal 1000.
then
it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks
"Otto Moehrbach" wrote:

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

.

.

.

Hi Bowmanator
I'm glad to see you're going with Otto's macro. I tried different things but to
no avail.
To crack this one, we would need help from the community if it can be done with
formulas.
You need to go below 1000, that brings more problems, the first one I sent you
will go below 1000 only if the total with the balance is over 1000.
Hope that Otto can fixe that for you.
Let us know if you get it working.
Good luck
John

"Bowmanator" wrote in message
...
yes but never applied a marco before so i'm trying to read up on it

"John" wrote:

Hi
You're right, a "bug", the formula I used in column C is no good for this
application.
I need to rethink this over, don't know if I've got time today.
Did you look the macro that Otto Moehrbach sent you, it works very well from
what I can see.
Anyway, I will have a look and see if I can correct the problem. It's the
"MIN()
formula in the other cells that is giving me the problem,
I may need to rethink and start new.
Will post back.
Regards
John


"Bowmanator" wrote in message
...
John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will transfer
down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0
value
in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.


.

Re your first question. What and where the code does hangs on the location
of the Target cell. In your case, the Target cell is the Amount cell. That
was in Column B. If you want to change that to Column C, change the 2 to a
3 in this line in the first macro:
If Target.Column = 2 Then

Re your second question. That would involve a bit more. Exactly what would
you do, manually, if the amount was less than 1000. Consider both the
situation where the amount plus the WhatsLeft is more than 1000 and less
than 1000. WhatsLeft is the amount in the previous row and 3 columns to the
right of the Target cell (the 53 and 72 in your examples). Otto


"Bowmanator" wrote in message
...
Otto,

i figured out how to insert and run the marcos and it works great but i
have
a couple questions for you.

1. what would i need to change in the marcos if i wanted to add more
columns?

what it will look like is this
A B C D E F
1 date lot# amount previous crrent total


2. there is a possability that the amount would be less then 1000
is there something i can change? learning is great but tuff.

thanks


"Otto Moehrbach" wrote:

The macros below do what you want. The first macro is an event macro
that
fires whenever an entry is made in Column B. This macro must be placed
in
the sheet module of your sheet. To access that module, right-click on
the
sheet tab and select View Code. Paste this first macro into that module,
"X" out of the module to return to your sheet. The other 2 macros
including
everything from "Option Explicit" and below should be placed in a regular
module. Come back if you need more. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
If Target.Column = 2 Then
If Target.Row = 2 Then _
Call FirstEntry(Target)
If Target.Row 2 Then _
Call TheRestEntry(Target)
End If
End Sub

Option Explicit
Dim c As Long
Dim WhatsLeft As Long

Sub FirstEntry(TheCell As Range)
Dim cc As Long
Application.EnableEvents = False
cc = Int(TheCell / 1000)
For c = 0 To cc - 1
TheCell.Offset(c, 3) = 1000
Next c
WhatsLeft = TheCell.Value - cc * 1000
TheCell.Offset(cc, 3) = WhatsLeft
Application.EnableEvents = True
End Sub

Sub TheRestEntry(TheCell As Range)
Application.EnableEvents = False
TheCell.Offset(, 1) = TheCell.Offset(-1, 3)
TheCell.Offset(, 2) = 1000 - TheCell.Offset(, 1)
TheCell.Offset(, 3) = 1000
WhatsLeft = TheCell - TheCell.Offset(, 2)
For c = 1 To 100
If WhatsLeft = 1000 Then
TheCell.Offset(c, 3) = 1000
WhatsLeft = WhatsLeft - 1000
Else
TheCell.Offset(c, 3) = WhatsLeft
Exit For
End If
Next c
Application.EnableEvents = True
End Sub


"Bowmanator" wrote in message
...
forgot, i'm using office xp pro

"Bowmanator" wrote:

you assumed everything correct, and everything entered in b2 and below
will
be greater then 1,000.

"Otto Moehrbach" wrote:

You didn't say anything about what Excel should/could use as the
trigger to
fire the automation. For now I'll assume it's any numerical entry
made
in
Column B below row 1. Excel can do lots for you with this but it
must
be
told every little detail so I have a question.
Question: Is every entry in Column B ALWAYS 1000 or greater? If
not,
and
the sum of that entry and the "leftover" (53 in your 3/10 example)
is
less
than 1000, what do you want to happen?
Another question: What version of Excel are you using? Otto

"Bowmanator" wrote in message
...

what i'm doing here is trying to keep track of how many full truck
loads i
can ship before i run out of product that was ran on a certain
day.
then
the
next load will be a split load.

ex: on 3/10 we ran 2053 cases, that allows me to ship 2 full loads
of
that
days run leaving 53 cases left,
on 3/11 we run 1019 so in order to ship a full load of 1,000 i'll
need the
53 cases left over from 3/10 plus 947 caes from 3/11 to equal
1000.
then
it
shows a balance of 72 let over from 3/11

hope this sounds better

thanks
"Otto Moehrbach" wrote:

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

.

.

.

Hi Bowmanator
How is it going,
I "think" I got it this time, If you can't get it with the macro,
post back and I will post the link to the file.
Regards
John

"Bowmanator" wrote in message
...
yes but never applied a marco before so i'm trying to read up on it

"John" wrote:

Hi
You're right, a "bug", the formula I used in column C is no good for this
application.
I need to rethink this over, don't know if I've got time today.
Did you look the macro that Otto Moehrbach sent you, it works very well from
what I can see.
Anyway, I will have a look and see if I can correct the problem. It's the
"MIN()
formula in the other cells that is giving me the problem,
I may need to rethink and start new.
Will post back.
Regards
John


"Bowmanator" wrote in message
...
John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will transfer
down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0
value
in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.


.

Thanks, i'm waiting on otto's email response. you can send it if you want.

"John" wrote:

Hi Bowmanator
How is it going,
I "think" I got it this time, If you can't get it with the macro,
post back and I will post the link to the file.
Regards
John

"Bowmanator" wrote in message
...
yes but never applied a marco before so i'm trying to read up on it

"John" wrote:

Hi
You're right, a "bug", the formula I used in column C is no good for this
application.
I need to rethink this over, don't know if I've got time today.
Did you look the macro that Otto Moehrbach sent you, it works very well from
what I can see.
Anyway, I will have a look and see if I can correct the problem. It's the
"MIN()
formula in the other cells that is giving me the problem,
I may need to rethink and start new.
Will post back.
Regards
John


"Bowmanator" wrote in message
...
John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will transfer
down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0
value
in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.


.


.

Hi Bowmanator
This one looks good but check it good.
BTW, I would use Otto's macro if you've got it, because you won't have to worry
about all those formulas in the cells.
It's a cleaner approach.
I know VBA just enough to be dangerous!!! still learning.
http://cjoint.com/?dspvG4GQ5F

HTH
John


"Bowmanator" wrote in message
...
Thanks, i'm waiting on otto's email response. you can send it if you want.

"John" wrote:

Hi Bowmanator
How is it going,
I "think" I got it this time, If you can't get it with the macro,
post back and I will post the link to the file.
Regards
John

"Bowmanator" wrote in message
...
yes but never applied a marco before so i'm trying to read up on it

"John" wrote:

Hi
You're right, a "bug", the formula I used in column C is no good for this
application.
I need to rethink this over, don't know if I've got time today.
Did you look the macro that Otto Moehrbach sent you, it works very well
from
what I can see.
Anyway, I will have a look and see if I can correct the problem. It's the
"MIN()
formula in the other cells that is giving me the problem,
I may need to rethink and start new.
Will post back.
Regards
John


"Bowmanator" wrote in message
...
John,

that's exactly what i'm looking for, i just have 1 question though.

don't know if i'll explain it right but i'll give it a try.

the formulas work great except when the results are more then two.

example, in the attachment you sent the leftover from C14 and F14
transfered down to C18 like it should, but since there is more than
1 result under the 3/18/2010 entry the final result C21 and F21
dosen't transfer, but if the final balance ended at C19 it will transfer
down.

hope it doesn't sound to confussing.

thanks

"John" wrote:

I sent you the wrong link, try this one:
http://cjoint.com/?dqnlFNldPq
John
"John" wrote in message
...
Hi Bowmanator

Try this one, I changed the formula in column C to accommodate the 0
value
in
the Balance column.
I think this is what you want in Column D.
http://cjoint.com/?dprqqVSBia

HTH
John

"Bowmanator" wrote in message
...
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

.



.


.


.

I responded to your post where you asked about changing the code, and asked
you a question. Did you see that? 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

Sorry, i totally missed your reply.

This is a long post showing the way i do it now.

right now my manual log looks nothing like what i'm trying to pull off with
this.
the way it looks if i want to keep using the example in my first post i'll
have to add yet another column incase
i run into a 3 split load.

right now all i do is take the production and break it down in to loads.

an example would be like this, going off the production log

Production log
Date Lot# Amount
2/8/10 123 450
2/9/10 124 200
2/10/10 125 1250
2/14/10 126 1580
2/15/10 127 500
2/16/10 128 3175

now going off the production log above my shipping log as of now looks like
this.

Shipping Log

Load # Date Lot # Amount
shipped
1 2/16/10 123 450
124 200
125 350
2 2/18/10 125 900
126 100
3 2/19/10 126 1000
4 2/21/10 126 480
5 127 500
128 20
6 2/22/10 128 1000
7 2/22/10 128 1000
8 2/22/10 128 1000
9 128 155

sorry for all the grief i'm causing, i think i'm making it more complicated
then necessary.
I'm just trying to come up with something that i can just type in one number
and it'll do the rest.

I'm not cometed to anything yet, so if you guys can come up with something
that's simple and sweet i'm all for it.

Thanks

PS. if this is to much trouble i understand, no hard feelings.


"Otto Moehrbach" wrote:

I responded to your post where you asked about changing the code, and asked
you a question. Did you see that? 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

.

Whatever any of us come up with, if it's a macro, will simply be a set of
instructions telling Excel what to do in any given situation. That last
part "in any given situation" puts the onus on you. In short, this means
that you MUST clearly define what the different situations are and clearly
define what you want Excel to do in each situation. Things like "you enter
a number less than, equal to, greater than, some value, in some column"
(what column?) Remember that Excel is dumb and has no idea what you want
to happen in each different situation. So you need to decide what all the
possibilities are and what you want to happen for each. HTH Otto

"Bowmanator" wrote in message
...
Sorry, i totally missed your reply.

This is a long post showing the way i do it now.

right now my manual log looks nothing like what i'm trying to pull off
with
this.
the way it looks if i want to keep using the example in my first post i'll
have to add yet another column incase
i run into a 3 split load.

right now all i do is take the production and break it down in to loads.

an example would be like this, going off the production log

Production log
Date Lot# Amount
2/8/10 123 450
2/9/10 124 200
2/10/10 125 1250
2/14/10 126 1580
2/15/10 127 500
2/16/10 128 3175

now going off the production log above my shipping log as of now looks
like
this.

Shipping Log

Load # Date Lot # Amount
shipped
1 2/16/10 123 450
124 200
125 350
2 2/18/10 125 900
126 100
3 2/19/10 126 1000
4 2/21/10 126 480
5 127 500
128 20
6 2/22/10 128 1000
7 2/22/10 128 1000
8 2/22/10 128 1000
9 128 155

sorry for all the grief i'm causing, i think i'm making it more
complicated
then necessary.
I'm just trying to come up with something that i can just type in one
number
and it'll do the rest.

I'm not cometed to anything yet, so if you guys can come up with something
that's simple and sweet i'm all for it.

Thanks

PS. if this is to much trouble i understand, no hard feelings.


"Otto Moehrbach" wrote:

I responded to your post where you asked about changing the code, and
asked
you a question. Did you see that? 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

.

sorry it took so long to respond, it's hard to type what i'm thinking.

i think i've covered all the bases but wrote it on the actual sheet i'm
using and would like to post it.

what program can i use to upload it here.


"Otto Moehrbach" wrote:

Whatever any of us come up with, if it's a macro, will simply be a set of
instructions telling Excel what to do in any given situation. That last
part "in any given situation" puts the onus on you. In short, this means
that you MUST clearly define what the different situations are and clearly
define what you want Excel to do in each situation. Things like "you enter
a number less than, equal to, greater than, some value, in some column"
(what column?) Remember that Excel is dumb and has no idea what you want
to happen in each different situation. So you need to decide what all the
possibilities are and what you want to happen for each. HTH Otto

"Bowmanator" wrote in message
...
Sorry, i totally missed your reply.

This is a long post showing the way i do it now.

right now my manual log looks nothing like what i'm trying to pull off
with
this.
the way it looks if i want to keep using the example in my first post i'll
have to add yet another column incase
i run into a 3 split load.

right now all i do is take the production and break it down in to loads.

an example would be like this, going off the production log

Production log
Date Lot# Amount
2/8/10 123 450
2/9/10 124 200
2/10/10 125 1250
2/14/10 126 1580
2/15/10 127 500
2/16/10 128 3175

now going off the production log above my shipping log as of now looks
like
this.

Shipping Log

Load # Date Lot # Amount
shipped
1 2/16/10 123 450
124 200
125 350
2 2/18/10 125 900
126 100
3 2/19/10 126 1000
4 2/21/10 126 480
5 127 500
128 20
6 2/22/10 128 1000
7 2/22/10 128 1000
8 2/22/10 128 1000
9 128 155

sorry for all the grief i'm causing, i think i'm making it more
complicated
then necessary.
I'm just trying to come up with something that i can just type in one
number
and it'll do the rest.

I'm not cometed to anything yet, so if you guys can come up with something
that's simple and sweet i'm all for it.

Thanks

PS. if this is to much trouble i understand, no hard feelings.


"Otto Moehrbach" wrote:

I responded to your post where you asked about changing the code, and
asked
you a question. Did you see that? 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

.

.

You shouldn't post it here. No one will read it. Instead send it to me via
email. My email is . Remove the "extra" from
this email. Identify yourself as Bowmanator so that I can look back at your
posts. Otto

"Bowmanator" wrote in message
...
sorry it took so long to respond, it's hard to type what i'm thinking.

i think i've covered all the bases but wrote it on the actual sheet i'm
using and would like to post it.

what program can i use to upload it here.


"Otto Moehrbach" wrote:

Whatever any of us come up with, if it's a macro, will simply be a set of
instructions telling Excel what to do in any given situation. That last
part "in any given situation" puts the onus on you. In short, this means
that you MUST clearly define what the different situations are and
clearly
define what you want Excel to do in each situation. Things like "you
enter
a number less than, equal to, greater than, some value, in some column"
(what column?) Remember that Excel is dumb and has no idea what you
want
to happen in each different situation. So you need to decide what all
the
possibilities are and what you want to happen for each. HTH Otto

"Bowmanator" wrote in message
...
Sorry, i totally missed your reply.

This is a long post showing the way i do it now.

right now my manual log looks nothing like what i'm trying to pull off
with
this.
the way it looks if i want to keep using the example in my first post
i'll
have to add yet another column incase
i run into a 3 split load.

right now all i do is take the production and break it down in to
loads.

an example would be like this, going off the production log

Production log
Date Lot# Amount
2/8/10 123 450
2/9/10 124 200
2/10/10 125 1250
2/14/10 126 1580
2/15/10 127 500
2/16/10 128 3175

now going off the production log above my shipping log as of now looks
like
this.

Shipping Log

Load # Date Lot # Amount
shipped
1 2/16/10 123 450
124 200
125 350
2 2/18/10 125 900
126 100
3 2/19/10 126 1000
4 2/21/10 126 480
5 127 500
128 20
6 2/22/10 128 1000
7 2/22/10 128 1000
8 2/22/10 128 1000
9 128 155

sorry for all the grief i'm causing, i think i'm making it more
complicated
then necessary.
I'm just trying to come up with something that i can just type in one
number
and it'll do the rest.

I'm not cometed to anything yet, so if you guys can come up with
something
that's simple and sweet i'm all for it.

Thanks

PS. if this is to much trouble i understand, no hard feelings.


"Otto Moehrbach" wrote:

I responded to your post where you asked about changing the code, and
asked
you a question. Did you see that? 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

.

.