is this even possible?

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

.

.