[Help] Auto Display into Different Month and Math

[coconutwei]

CUST

PRODUCT

PACKING

DATE

QTY

1/14

2/14

3/14

4/14

5/14

6/14

7/14

8/14

PBMW02

ACCU CHEK ADV 2 STRIP

25'S

Jan-14

2

PBMW02

ACCU CHEK ADV 2 STRIP

25'S

Feb-14

1

PBMW02

ACCU CHEK ADV 2 STRIP

25'S

Feb-14

1

PBMW02

ACCU CHEK ADV 2 STRIP

25'S

Mar-14

2

PBMW02

ACCU CHEK ADV 2 STRIP

25'S

Apr-14

1

PBMW02

ACCU CHEK ADV 2 STRIP

25'S

May-14

2

PBMW02

ACUGESIC TAB 50MG (BLIS)

10X10'S

Jan-14

1

PBMW02

ACUGESIC TAB 50MG (BLIS)

10X10'S

Jul-14

1

PBMW02

ADROTEN 5MG TAB

10X10'S

Jan-14

1

PBMW02

ADROTEN 5MG TAB

10X10'S

Apr-14

1

PBMW02

ALATROL TAB 10MG (W)

10X10'S

Jan-14

5

PBMW02

ALATROL TAB 10MG (W)

10X10'S

Jan-14

5

PBMW02

ARCOXIA 90MG TAB

10X10'S

Apr-14

1

PBMW02

ARISONE CREAM 1%

50G

May-14

2

PBMW02

ARISONE CREAM 1%

50G

Jul-14

5

PBMW02

ASTHALIN INHALER

200D

Feb-14

5

PBMW02

AT CHLORPYRIMINE INJ 10ML

1VL

Jan-14

5

PBMW02

AT CLOFEC INJ 75/3ML

50AMP

Feb-14

0

PBMW02

AT DEXASONE INJ 5MG/ML

50AMP

Jul-14

0

PBMW02

AT DEXASONE TAB

50X10'S

Jan-14

2

PBMW02

AT DEXASONE TAB

50X10'S

Feb-14

1

PBMW02

AT DEXASONE TAB

50X10'S

Jul-14

2

<colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

.
.
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?