is this even possible?
in [General]
|
Prev: Excel file slow
Next: excell
From: John on 17 Mar 2010 20:23 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" <Bowmanator(a)discussions.microsoft.com> wrote in message news:18EB615D-FC99-4EBA-890D-0DD3408F240B(a)microsoft.com... > 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" <Bowmanator(a)discussions.microsoft.com> wrote in message >> news:FC809595-BCF0-4B5F-8FF6-8C04EEFE3549(a)microsoft.com... >> > 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" <johnd(a)newlook.com> wrote in message >> >> news:%231fw2MQxKHA.3896(a)TK2MSFTNGP02.phx.gbl... >> >> > 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" <Bowmanator(a)discussions.microsoft.com> wrote in message >> >> > news:910EFD52-BAF1-4D49-AA48-447F24DF7C35(a)microsoft.com... >> >> >> 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" <Bowmanator(a)discussions.microsoft.com> wrote in message >> >> >>> news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... >> >> >>> > 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 >> >> >>> >> >> >>> . >> >> >>> >> >> > >> >> >> >> . >> >> >> >> . >>
From: Bowmanator on 17 Mar 2010 22:18 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" <Bowmanator(a)discussions.microsoft.com> wrote in message > news:18EB615D-FC99-4EBA-890D-0DD3408F240B(a)microsoft.com... > > 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" <Bowmanator(a)discussions.microsoft.com> wrote in message > >> news:FC809595-BCF0-4B5F-8FF6-8C04EEFE3549(a)microsoft.com... > >> > 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" <johnd(a)newlook.com> wrote in message > >> >> news:%231fw2MQxKHA.3896(a)TK2MSFTNGP02.phx.gbl... > >> >> > 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" <Bowmanator(a)discussions.microsoft.com> wrote in message > >> >> > news:910EFD52-BAF1-4D49-AA48-447F24DF7C35(a)microsoft.com... > >> >> >> 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" <Bowmanator(a)discussions.microsoft.com> wrote in message > >> >> >>> news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... > >> >> >>> > 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 > >> >> >>> > >> >> >>> . > >> >> >>> > >> >> > > >> >> > >> >> . > >> >> > >> > >> . > >> > > . >
From: John on 18 Mar 2010 13:03 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" <Bowmanator(a)discussions.microsoft.com> wrote in message news:E0194A3E-156F-4642-A153-F5BC67001A59(a)microsoft.com... > 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" <Bowmanator(a)discussions.microsoft.com> wrote in message >> news:18EB615D-FC99-4EBA-890D-0DD3408F240B(a)microsoft.com... >> > 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" <Bowmanator(a)discussions.microsoft.com> wrote in message >> >> news:FC809595-BCF0-4B5F-8FF6-8C04EEFE3549(a)microsoft.com... >> >> > 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" <johnd(a)newlook.com> wrote in message >> >> >> news:%231fw2MQxKHA.3896(a)TK2MSFTNGP02.phx.gbl... >> >> >> > 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" <Bowmanator(a)discussions.microsoft.com> wrote in message >> >> >> > news:910EFD52-BAF1-4D49-AA48-447F24DF7C35(a)microsoft.com... >> >> >> >> 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" <Bowmanator(a)discussions.microsoft.com> wrote in >> >> >> >>> message >> >> >> >>> news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... >> >> >> >>> > 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 >> >> >> >>> >> >> >> >>> . >> >> >> >>> >> >> >> > >> >> >> >> >> >> . >> >> >> >> >> >> >> . >> >> >> >> . >>
From: Otto Moehrbach on 19 Mar 2010 12:36 I responded to your post where you asked about changing the code, and asked you a question. Did you see that? Otto "Bowmanator" <Bowmanator(a)discussions.microsoft.com> wrote in message news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... > 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
From: Bowmanator on 20 Mar 2010 11:42
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" <Bowmanator(a)discussions.microsoft.com> wrote in message > news:66821ED8-2133-4A80-B286-702D0F01558B(a)microsoft.com... > > 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 > > . > |