Hello:
Please refer to attached file.
Every day I get report data as shown in column A thru E
Column A : Date
Column B : Item
Column C : Qty
Column D : % Items
Column E : Amount
Column F : % Amount
I need a VB Cdoe to summarize daily data as shown in column K thru AP.
Cell L2:AP2 list the items
Cell K3 down shows each day of the year.
Basically the code need to ask :
Which data do i need to use:
1 Qty
2 % Items
3 Amount
4 %Amount
Depending on above selection, code would need to use data from column C,D,E or F.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks