[Help] Auto Display into Different Month and Math

[coconutwei]

[TABLE="class: grid, width: 822, align: left"]
<colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]CUST
[/TD]
[TD]PRODUCT
[/TD]
[TD]PACKING
[/TD]
[TD]DATE
[/TD]
[TD] QTY
[/TD]
[TD] 1/14
[/TD]
[TD]2/14
[/TD]
[TD]3/14
[/TD]
[TD]4/14
[/TD]
[TD]5/14
[/TD]
[TD]6/14
[/TD]
[TD]7/14
[/TD]
[TD]8/14
[/TD]
[/TR]
[TR]
[TD]PBMW02
[/TD]
[TD]ACCU CHEK ADV 2 STRIP
[/TD]
[TD]25'S[/TD]
[TD="align: right"]Jan-14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ACCU CHEK ADV 2 STRIP[/TD]
[TD]25'S[/TD]
[TD="align: right"]Feb-14[/TD]
[TD]1[/TD]
[TD]
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ACCU CHEK ADV 2 STRIP[/TD]
[TD]25'S[/TD]
[TD="align: right"]Feb-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ACCU CHEK ADV 2 STRIP[/TD]
[TD]25'S[/TD]
[TD="align: right"]Mar-14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ACCU CHEK ADV 2 STRIP[/TD]
[TD]25'S[/TD]
[TD="align: right"]Apr-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ACCU CHEK ADV 2 STRIP[/TD]
[TD]25'S[/TD]
[TD="align: right"]May-14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ACUGESIC TAB 50MG (BLIS)[/TD]
[TD]10X10'S[/TD]
[TD="align: right"]Jan-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ACUGESIC TAB 50MG (BLIS)[/TD]
[TD]10X10'S[/TD]
[TD="align: right"]Jul-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ADROTEN 5MG TAB[/TD]
[TD]10X10'S[/TD]
[TD="align: right"]Jan-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ADROTEN 5MG TAB[/TD]
[TD]10X10'S[/TD]
[TD="align: right"]Apr-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ALATROL TAB 10MG (W)[/TD]
[TD]10X10'S[/TD]
[TD="align: right"]Jan-14[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ALATROL TAB 10MG (W)[/TD]
[TD]10X10'S[/TD]
[TD="align: right"]Jan-14[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ARCOXIA 90MG TAB[/TD]
[TD]10X10'S[/TD]
[TD="align: right"]Apr-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ARISONE CREAM 1%[/TD]
[TD]50G[/TD]
[TD="align: right"]May-14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ARISONE CREAM 1%[/TD]
[TD]50G[/TD]
[TD="align: right"]Jul-14[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]ASTHALIN INHALER[/TD]
[TD]200D[/TD]
[TD="align: right"]Feb-14[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]AT CHLORPYRIMINE INJ 10ML[/TD]
[TD]1VL[/TD]
[TD="align: right"]Jan-14[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]AT CLOFEC INJ 75/3ML[/TD]
[TD]50AMP[/TD]
[TD="align: right"]Feb-14[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]AT DEXASONE INJ 5MG/ML[/TD]
[TD]50AMP[/TD]
[TD="align: right"]Jul-14[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]AT DEXASONE TAB[/TD]
[TD]50X10'S[/TD]
[TD="align: right"]Jan-14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]AT DEXASONE TAB[/TD]
[TD]50X10'S[/TD]
[TD="align: right"]Feb-14[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PBMW02[/TD]
[TD]AT DEXASONE TAB[/TD]
[TD]50X10'S[/TD]
[TD="align: right"]Jul-14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]





.
.
Greeting to all the Excel Programming Expert,

Long time ago, I received some helps on Excel formula here. I thanks them.
Today, while I was doing this, I thought of this forum, and I believed there must be something that can be done.

Above is spreadsheet of what I am currently doing.
I have a very large database of invoices, and I was asked to put the ordered quantity into each column of Month/Year.
What I am currently doing is, I manually type one by one, but I believe there must be something can be done to ease this pain. (For your info, there are around 40k of records)

I appreciate if anyone can tell me if there is a formula to be used.
The complexion of this is beyond my Excel knowledge.

What I need is,
- If the buyer bought the item on Feb, Mar, Apr, with 1-1-2 each, then the column below 2/14, 3/14, 4/14, will appeared with number 1,1,2 each.
- If there are 2 purchases over the same item on the same month, assuming Apr, 2+2, then the column will display 1,1,4 each.



Thanks in Advanced,
Coconutwei

 

[coconutwei]

I just realized, the threads moved so fast. My question got pushed to the 3rd page in hours. LOL.
Maybe I can pay someone for helping me out? :P

p/s : Can anyone tell me how to attach Excel file?