Dynamic subtotals macro to

[RAM1972]

Hi All Guys

I have to 2 format templates sheets but same principle apply for both

Make a subtotal of Tariff description origin header as the primary key with qty litres sugar and amount

the other format does not contain litres and sugar but header column slightly differ see attached sheet

One sheet expected results column headers O,P,S,T

ANOTHER WORKBOOK sheet expected results column HEADERS L, M N O T V.

Actually doing manually with subtotals, F5 SPECIAL VISIBLE CELLS AND COPY REQUIRED HEADERS TO SUMMARY.

Looking for a macro to make dynamic subtotals for these colums mentioned above and then transfered it summary sheet for further process as it is repetitive process each time so as save me time I am overloaded andme crazy

Note the subtotals can reach up 900 subtotals with a data set of 10000 to to 15000 rows .

Hope anyone who knows vba to help me in this tedious task am looking looking to automate this process


Original data

PO	Supplier	Invoice No	Page	Line	Manifeste Po	ORIGIN	Tariff	Description	LEN	PORLREV	ITEMNO	ITEMDESC	VENDITEMNO	Tariff Description Origin	Supp Qty	OQOUTSTAND	UNITCOST	EXTENTED	Itemised	Details
12776	aaaaaaa	15063175	P1	1	14	FR	32089010	VARNISHES	8	1000	0058905	VERNIS MARIN 0,5L BRILLANT INCOLORE	106135	32089010 VARNISHES FR	2	2	9.06	18.12		1
12776	scds	15063175	P1	2	14	FR	32089010	VARNISHES	8	2000	0058896	VERNIS EXTERIEUR BSC 0,5L BRILLANT INCOLORE	13962	32089010 VARNISHES FR	2	2	8.21	16.42		1
12776	vdsv	15063175	P1	3	14	FR	32089010	VARNISHES	8	3000	0058899	VERNIS EXTERIEUR BSC 0,5L SATINE INCOLORE	13963	32089010 VARNISHES FR	2	2	8.21	16.42		1
12776	sdsfsd	15063175	P1	4	14	FR	32089010	VARNISHES	8	4000	0058900	VERNIS EXTERIEUR BSC 1L SATINE INCOLORE	13971	32089010 VARNISHES FR	2	2	13.99	27.98		1
12776	dsvdsvs	15063175	P1	5	14	FR	32089010	VARNISHES	8	5000	0058907	VERNIS MARIN 1L BRILLANT INCOLORE	13980	32089010 VARNISHES FR	2	2	15.38	30.76		1
12776	dsvdsvs	15063175	P1	6	14	FR	32089010	VARNISHES	8	6000	0058906	VERNIS MARIN 0,5L BRILLANT AMBRE	314420	32089010 VARNISHES FR	4	4	9.06	36.24		1
12776	sdvsdvsdv	15063175	P1	7	14	FR	32089010	VARNISHES	8	7000	0058908	VERNIS MARIN 1L BRILLANT AMBRE	314421	32089010 VARNISHES FR	2	2	15.38	30.76		1
12776	sdvsdvsdv	15063175	P1	8	14	FR	32089010	VARNISHES	8	8000	0058913	VERNIS CUISINE SALLE DE BAINS AQUA 0,5L INCOLORE NATUREL	314451	32089010 VARNISHES FR	2	2	7.6	15.2		1
12776	sdvsdvsdv	15063175	P1	9	14	FR	32089010	VARNISHES	8	9000	0058914	VERNIS CUISINE SALLE DE BAINS AQUA 1L INCOLORE NATUREL	314462	32089010 VARNISHES FR	3	3	13.04	39.12		1
12776	sdvsdvsdv	15063175	P1	10	14	FR	32089010	VARNISHES	8	10000	0058902	VERNIS EXTERIEUR BSC 0,5L MAT INCOLORE	53504	32089010 VARNISHES FR	1	1	8.21	8.21		1
12776	sdvsdvsdv	15063175	P1	11	14	FR	32089010	VARNISHES	8	11000	0058909	VERNIS MARIN 0,5L SATINE INCOLORE	537890	32089010 VARNISHES FR	4	4	9.06	36.24		1
12776	sdvsdvsdv	15063175	P2	1	14	FR	32089010	VARNISHES	8	12000	0058912	VERNIS EXTERIEUR ULTRA RESISTANT 1L INCOLORE	537909	32089010 VARNISHES FR	2	2	18.35	36.7		1
12998	sdvsdvsdv	1520249	P3	7	13	FR	39172900	TUBE	8	51000	0045015	TUBE ROND PVC BLANC 10X1,2-1 M	2002-80460	39172900 TUBE FR	10	10	0.58	5.8		1
12992	sdvsdvsdv	15620151	P1	17	19	CN	39173300	FLEXIBLE TUBINGS	8	18000	0065611	FLEXIBLE ACIER INOXYDABLE 150 CM - COULEUR CHROME	3100102	39173300 FLEXIBLE TUBINGS CN	6	6	1.4283	8.5698		1
12992	sdvsdvsdv	15620151	P1	18	19	CN	39173300	FLEXIBLE TUBINGS	8	19000	0065614	FLEXIBLE PVC 150 CM - NOIR/ARGENT	3103103	39173300 FLEXIBLE TUBINGS CN	6	6	1.2883	7.7298		1
12992	sdvsdvsdv	15620151	P1	19	19	CN	39173300	FLEXIBLE TUBINGS	8	20000	0065617	FLEXIBLE PVC 200 CM - BLANC/ARGENT	3107100	39173300 FLEXIBLE TUBINGS CN	6	6	1.738	10.428		1
12992	sdvsdvsdv	15620151	P1	20	19	CN	39173300	FLEXIBLE TUBINGS	8	21000	0065618	FLEXIBLE PVC 200CM - NOIR/ARGENT	3108103	39173300 FLEXIBLE TUBINGS CN	6	6	1.7383	10.4298		1
12992	sdvsdvsdv	15620151	P1	21	19	CN	39173300	FLEXIBLE TUBINGS	8	22000	0065619	FLEXIBLE EXTENSIBLE ACIER INOXYDABLE 180 A 230 CM - COULEUR	3109102	39173300 FLEXIBLE TUBINGS CN	6	6	2.52	15.12		1
12992	sdvsdvsdv	15620151	P2	1	19	CN	39173300	FLEXIBLE TUBINGS	8	23000	0065620	FLEXIBLE PVC 200 CM - GRIS	3111180	39173300 FLEXIBLE TUBINGS CN	6	6	1.9366	11.6196		1
12992	sdvsdvsdv	15620151	P2	12	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	34000	0065633	KIT DOUCHETTE 1 FONCTION ANTICALCAIRE + FLEXIBLE 150 CM - CO	3300102	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	3.148	18.888		1
12992	sdvsdvsdv	15620151	P2	13	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	35000	0065635	KIT DOUCHETTE 1 FONCTION PVC BLANC + FLEXIBLE PVC 150CM - BL	3302100	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	2.763	16.578		1
12992	sdvsdvsdv	15620151	P2	14	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	36000	0065637	KIT BARRE + DOUCHETTE 4 FONCTIONS ET ANTICALCAIRE + FLEXIBLE	3401102	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	9.203	55.218		1
12992	sdvsdvsdv	15620151	P2	15	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	37000	0065638	KIT BARRE CARREE 60 CM+DOUCHETTE RECTANGULAIRE 1FONCTION+FLE	3403102	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	9.1	54.6		1
12770	sdvsdvsdv	298435	P1	1	15	FR	39209900	PLASTIC SHEETS	8	1000	0012855	STYROGLASS CLAIR LISSE 2,5MM2 X 1 M	60101	39209900 PLASTIC SHEETS FR	1	1	25.31	25.31		1
12770	sdvsdvsdv	298435	P1	2	15	FR	39209900	PLASTIC SHEETS	8	2000	0012854	STYROGLASS CYRUS CLAIR 2,5MM2 X 1 M	60102	39209900 PLASTIC SHEETS FR	3	3	25.31	75.93		1
12770	sdvsdvsdv	298435	P1	3	15	FR	39209900	PLASTIC SHEETS	8	4000	0012850	STYROGLASS ANTIQUE CLAIR 2,5MM2 X 1 M	60134	39209900 PLASTIC SHEETS FR	1	1	25.31	25.31		1
12770	sdvsdvsdv	298435	P1	4	15	FR	39209900	PLASTIC SHEETS	8	5000	0012851	STYROGLASS ANTIQUE JAUNE 2,5MM2 X 1 M	60135	39209900 PLASTIC SHEETS FR	1	1	25.31	25.31		1
12770	sdvsdvsdv	298435	P1	5	15	FR	39209900	PLASTIC SHEETS	8	6000	0012833	STYROGLASS CLAIR LISSE 2,5MM1 X 1 M	60201	39209900 PLASTIC SHEETS FR	1	1	12.65	12.65		1
12770	sdvsdvsdv	298435	P1	6	15	FR	39209900	PLASTIC SHEETS	8	7000	0012813	STYROGLASS CYRUS CLAIR 2,5MM0,50 X 1 M	60302	39209900 PLASTIC SHEETS FR	1	1	6.33	6.33		1
12770	sdvsdvsdv	298435	P1	7	15	FR	39209900	PLASTIC SHEETS	8	8000	0012857	STYROGLASS CYRUS CLAIR 5MM1 X 1 M	65202	39209900 PLASTIC SHEETS FR	2	2	25.31	50.62		1
12770	sdvsdvsdv	298435	P1	8	15	FR	39209900	PLASTIC SHEETS	8	9000	0012817	STYROGLASS CLAIR LISSE 0.50X0.50 5MM0,50 X 1 M	65501	39209900 PLASTIC SHEETS FR	3	3	6.33	18.99		1
12770	sdvsdvsdv	298435	P1	9	15	FR	39209900	PLASTIC SHEETS	8	10000	0012882	STYROGLASS EN ROULEAU 1MM-1,25M - T35	67125	39209900 PLASTIC SHEETS FR	35	35	6.78286	237.4		1

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

doing subtotals manually macro require

PO	Supplier	Invoice No	Page	Line	Manifeste Po	ORIGIN	Tariff	Description	LEN	PORLREV	ITEMNO	ITEMDESC	VENDITEMNO	Tariff Description Origin	Supp Qty	OQOUTSTAND	UNITCOST	EXTENTED	Itemised	Details
12776	aaaaaaa	15063175	P1	1	14	FR	32089010	VARNISHES	8	1000	0058905	VERNIS MARIN 0,5L BRILLANT INCOLORE	106135	32089010 VARNISHES FR	2	2	9.06	18.12		1
12776	scds	15063175	P1	2	14	FR	32089010	VARNISHES	8	2000	0058896	VERNIS EXTERIEUR BSC 0,5L BRILLANT INCOLORE	13962	32089010 VARNISHES FR	2	2	8.21	16.42		1
12776	vdsv	15063175	P1	3	14	FR	32089010	VARNISHES	8	3000	0058899	VERNIS EXTERIEUR BSC 0,5L SATINE INCOLORE	13963	32089010 VARNISHES FR	2	2	8.21	16.42		1
12776	sdsfsd	15063175	P1	4	14	FR	32089010	VARNISHES	8	4000	0058900	VERNIS EXTERIEUR BSC 1L SATINE INCOLORE	13971	32089010 VARNISHES FR	2	2	13.99	27.98		1
12776	dsvdsvs	15063175	P1	5	14	FR	32089010	VARNISHES	8	5000	0058907	VERNIS MARIN 1L BRILLANT INCOLORE	13980	32089010 VARNISHES FR	2	2	15.38	30.76		1
12776	dsvdsvs	15063175	P1	6	14	FR	32089010	VARNISHES	8	6000	0058906	VERNIS MARIN 0,5L BRILLANT AMBRE	314420	32089010 VARNISHES FR	4	4	9.06	36.24		1
12776	sdvsdvsdv	15063175	P1	7	14	FR	32089010	VARNISHES	8	7000	0058908	VERNIS MARIN 1L BRILLANT AMBRE	314421	32089010 VARNISHES FR	2	2	15.38	30.76		1
12776	sdvsdvsdv	15063175	P1	8	14	FR	32089010	VARNISHES	8	8000	0058913	VERNIS CUISINE SALLE DE BAINS AQUA 0,5L INCOLORE NATUREL	314451	32089010 VARNISHES FR	2	2	7.6	15.2		1
12776	sdvsdvsdv	15063175	P1	9	14	FR	32089010	VARNISHES	8	9000	0058914	VERNIS CUISINE SALLE DE BAINS AQUA 1L INCOLORE NATUREL	314462	32089010 VARNISHES FR	3	3	13.04	39.12		1
12776	sdvsdvsdv	15063175	P1	10	14	FR	32089010	VARNISHES	8	10000	0058902	VERNIS EXTERIEUR BSC 0,5L MAT INCOLORE	53504	32089010 VARNISHES FR	1	1	8.21	8.21		1
12776	sdvsdvsdv	15063175	P1	11	14	FR	32089010	VARNISHES	8	11000	0058909	VERNIS MARIN 0,5L SATINE INCOLORE	537890	32089010 VARNISHES FR	4	4	9.06	36.24		1
12776	sdvsdvsdv	15063175	P2	1	14	FR	32089010	VARNISHES	8	12000	0058912	VERNIS EXTERIEUR ULTRA RESISTANT 1L INCOLORE	537909	32089010 VARNISHES FR	2	2	18.35	36.7		1
														32089010 VARNISHES FR Total	28			312.17	1
12998	sdvsdvsdv	1520249	P3	7	13	FR	39172900	TUBE	8	51000	0045015	TUBE ROND PVC BLANC 10X1,2-1 M	2002-80460	39172900 TUBE FR	10	10	0.58	5.8		2
														39172900 TUBE FR Total	10			5.8	2
12992	sdvsdvsdv	15620151	P1	17	19	CN	39173300	FLEXIBLE TUBINGS	8	18000	0065611	FLEXIBLE ACIER INOXYDABLE 150 CM - COULEUR CHROME	3100102	39173300 FLEXIBLE TUBINGS CN	6	6	1.4283	8.5698		3
12992	sdvsdvsdv	15620151	P1	18	19	CN	39173300	FLEXIBLE TUBINGS	8	19000	0065614	FLEXIBLE PVC 150 CM - NOIR/ARGENT	3103103	39173300 FLEXIBLE TUBINGS CN	6	6	1.2883	7.7298		3
12992	sdvsdvsdv	15620151	P1	19	19	CN	39173300	FLEXIBLE TUBINGS	8	20000	0065617	FLEXIBLE PVC 200 CM - BLANC/ARGENT	3107100	39173300 FLEXIBLE TUBINGS CN	6	6	1.738	10.428		3
12992	sdvsdvsdv	15620151	P1	20	19	CN	39173300	FLEXIBLE TUBINGS	8	21000	0065618	FLEXIBLE PVC 200CM - NOIR/ARGENT	3108103	39173300 FLEXIBLE TUBINGS CN	6	6	1.7383	10.4298		3
12992	sdvsdvsdv	15620151	P1	21	19	CN	39173300	FLEXIBLE TUBINGS	8	22000	0065619	FLEXIBLE EXTENSIBLE ACIER INOXYDABLE 180 A 230 CM - COULEUR	3109102	39173300 FLEXIBLE TUBINGS CN	6	6	2.52	15.12		3
12992	sdvsdvsdv	15620151	P2	1	19	CN	39173300	FLEXIBLE TUBINGS	8	23000	0065620	FLEXIBLE PVC 200 CM - GRIS	3111180	39173300 FLEXIBLE TUBINGS CN	6	6	1.9366	11.6196		3
														39173300 FLEXIBLE TUBINGS CN Total	36			63.897	3
12992	sdvsdvsdv	15620151	P2	12	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	34000	0065633	KIT DOUCHETTE 1 FONCTION ANTICALCAIRE + FLEXIBLE 150 CM - CO	3300102	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	3.148	18.888		4
12992	sdvsdvsdv	15620151	P2	13	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	35000	0065635	KIT DOUCHETTE 1 FONCTION PVC BLANC + FLEXIBLE PVC 150CM - BL	3302100	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	2.763	16.578		4
12992	sdvsdvsdv	15620151	P2	14	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	36000	0065637	KIT BARRE + DOUCHETTE 4 FONCTIONS ET ANTICALCAIRE + FLEXIBLE	3401102	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	9.203	55.218		4
12992	sdvsdvsdv	15620151	P2	15	19	CN	39173900	PLASTIC TUBINGS FOR SHOWER	8	37000	0065638	KIT BARRE CARREE 60 CM+DOUCHETTE RECTANGULAIRE 1FONCTION+FLE	3403102	39173900 PLASTIC TUBINGS FOR SHOWER CN	6	6	9.1	54.6		4
														39173900 PLASTIC TUBINGS FOR SHOWER CN Total	24			145.284	4
12770	sdvsdvsdv	298435	P1	1	15	FR	39209900	PLASTIC SHEETS	8	1000	0012855	STYROGLASS CLAIR LISSE 2,5MM2 X 1 M	60101	39209900 PLASTIC SHEETS FR	1	1	25.31	25.31		5
12770	sdvsdvsdv	298435	P1	2	15	FR	39209900	PLASTIC SHEETS	8	2000	0012854	STYROGLASS CYRUS CLAIR 2,5MM2 X 1 M	60102	39209900 PLASTIC SHEETS FR	3	3	25.31	75.93		5
12770	sdvsdvsdv	298435	P1	3	15	FR	39209900	PLASTIC SHEETS	8	4000	0012850	STYROGLASS ANTIQUE CLAIR 2,5MM2 X 1 M	60134	39209900 PLASTIC SHEETS FR	1	1	25.31	25.31		5
12770	sdvsdvsdv	298435	P1	4	15	FR	39209900	PLASTIC SHEETS	8	5000	0012851	STYROGLASS ANTIQUE JAUNE 2,5MM2 X 1 M	60135	39209900 PLASTIC SHEETS FR	1	1	25.31	25.31		5
12770	sdvsdvsdv	298435	P1	5	15	FR	39209900	PLASTIC SHEETS	8	6000	0012833	STYROGLASS CLAIR LISSE 2,5MM1 X 1 M	60201	39209900 PLASTIC SHEETS FR	1	1	12.65	12.65		5
12770	sdvsdvsdv	298435	P1	6	15	FR	39209900	PLASTIC SHEETS	8	7000	0012813	STYROGLASS CYRUS CLAIR 2,5MM0,50 X 1 M	60302	39209900 PLASTIC SHEETS FR	1	1	6.33	6.33		5
12770	sdvsdvsdv	298435	P1	7	15	FR	39209900	PLASTIC SHEETS	8	8000	0012857	STYROGLASS CYRUS CLAIR 5MM1 X 1 M	65202	39209900 PLASTIC SHEETS FR	2	2	25.31	50.62		5
12770	sdvsdvsdv	298435	P1	8	15	FR	39209900	PLASTIC SHEETS	8	9000	0012817	STYROGLASS CLAIR LISSE 0.50X0.50 5MM0,50 X 1 M	65501	39209900 PLASTIC SHEETS FR	3	3	6.33	18.99		5
12770	sdvsdvsdv	298435	P1	9	15	FR	39209900	PLASTIC SHEETS	8	10000	0012882	STYROGLASS EN ROULEAU 1MM-1,25M - T35	67125	39209900 PLASTIC SHEETS FR	35	35	6.782857	237.399995		5
														39209900 PLASTIC SHEETS FR Total	48			477.849995	5
Summary sheet Tariff Description Origin Supp Qty OQOUTSTAND UNITCOST EXTENTED Itemised 32089010 VARNISHES FR Total 28 312.17 1 39172900 TUBE FR Total 10 5.8 2 39173300 FLEXIBLE TUBINGS CN Total 36 63.897 3 39173900 PLASTIC TUBINGS FOR SHOWER CN Total 24 145.284 4 39209900 PLASTIC SHEETS FR Total 48 477.849995 5 Grand Total 146 1005.000995 <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody>														Grand Total	146			1005.000995

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

@2nd sample

PO	Invoice	Page	Line	Ref	Description of Goods	HS Code	Tariff No	Description	No of charct	Origin	Tarif No Description Origin	Qty_1	Litres	Sugar	Qty	QTY	Unit	@	Amount
564879	1111	P1	1	2855727	DATA	0901220000	09012200	GROUND COFFEE		ZA	09012200 GROUND COFFEE ZA	12			12.00EA	12.00	EA	1.93	23.16
564879	2222	P1	1	4074678	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	24			24.00EA	24.00	EA	2.51	60.24
564879	1111	P1	2	4074692	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	12			12.00EA	12.00	EA	2.51	30.12
564879	1111	P1	3	4074726	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	24			24.00EA	24.00	EA	2.51	60.24
564879	1111	P1	4	4074740	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	12			12.00EA	12.00	EA	2.51	30.12
564879	1111	P1	5	4074829	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	24			24.00EA	24.00	EA	2.51	60.24
564879	33333	P1	19	5017737	DATA	0402910000	04029100	EVAPORATD MILK		DE	04029100 EVAPORATD MILK DE	240			240.00EA	240.00	EA	0.61	146.40
564879	66666	P2	16	3951905	DATA	0402290000	04022900	CARAMEL TOPPING		UA	04022900 CARAMEL TOPPING UA	225			225.00EA	225.00	EA	0.79	177.75
564879	77777	P1	16	3837304	DATA	9619004000	96190040	SANITARY PADS		ZA	96190040 SANITARY PADS ZA	16			16.00EA	16.00	EA	0.61	9.76
564879	5555	P1	18	3568415	DATA	9619004000	96190040	SANITARY PADS		CN	96190040 SANITARY PADS CN	48			48.00EA	48.00	EA	0.50	24.00
564879	5555	P7	9	6502887	DATA	9615190000	96159000	HAIRSLIDES		CN	96159000 HAIRSLIDES CN	48			48.00EA	48.00	EA	0.51	24.48
564879	5555	P7	5	6556558	DATA	9615190000	96159000	HAIR CLIPS		CN	96159000 HAIR CLIPS CN	18			18.00EA	18.00	EA	0.17	3.06
564879	5555	P7	7	0616047	DATA	9615900000	96159000	HAIR CLIPS		CN	96159000 HAIR CLIPS CN	30			30.00EA	30.00	EA	0.26	7.80

<colgroup><col span="3"><col><col><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>

subtotals manually

PO	Invoice	Page	Line	Ref	Description of Goods	HS Code	Tariff No	Description	No of charct	Origin	Tarif No Description Origin	Qty_1	Litres	Sugar	Qty	QTY	Unit	@	Amount	DETAILS	ITEMISED
564879	1111	P1	1	2855727	DATA	0901220000	09012200	GROUND COFFEE		ZA	09012200 GROUND COFFEE ZA	12			12.00EA	12.00	EA	1.93	23.16	1	1
											09012200 GROUND COFFEE ZA Total	12	0	0					23.16		1
564879	2222	P1	1	4074678	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	24			24.00EA	24.00	EA	2.51	60.24	2	2
564879	1111	P1	2	4074692	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	12			12.00EA	12.00	EA	2.51	30.12	2
564879	1111	P1	3	4074726	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	24			24.00EA	24.00	EA	2.51	60.24	2
564879	1111	P1	4	4074740	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	12			12.00EA	12.00	EA	2.51	30.12	2
564879	1111	P1	5	4074829	DATA	0901210000	09012100	COFFEE		ZA	09012100 COFFEE ZA	24			24.00EA	24.00	EA	2.51	60.24	2
											09012100 COFFEE ZA Total	96	0	0					240.96		2
564879	33333	P1	19	5017737	DATA	0402910000	04029100	EVAPORATD MILK		DE	04029100 EVAPORATD MILK DE	240			240.00EA	240.00	EA	0.61	146.40	3
											04029100 EVAPORATD MILK DE Total	240	0	0					146.40		3
564879	66666	P2	16	3951905	DATA	0402290000	04022900	CARAMEL TOPPING		UA	04022900 CARAMEL TOPPING UA	225			225.00EA	225.00	EA	0.79	177.75	4
											04022900 CARAMEL TOPPING UA Total	225	0	0					177.75		4
564879	77777	P1	16	3837304	DATA	9619004000	96190040	SANITARY PADS		ZA	96190040 SANITARY PADS ZA	16			16.00EA	16.00	EA	0.61	9.76	5
											96190040 SANITARY PADS ZA Total	16	0	0					9.76		5
564879	5555	P1	18	3568415	DATA	9619004000	96190040	SANITARY PADS		CN	96190040 SANITARY PADS CN	48			48.00EA	48.00	EA	0.50	24.00	6
											96190040 SANITARY PADS CN Total	48	0	0					24.00		6
564879	5555	P7	9	6502887	DATA	9615190000	96159000	HAIRSLIDES		CN	96159000 HAIRSLIDES CN	48			48.00EA	48.00	EA	0.51	24.48	7
											96159000 HAIRSLIDES CN Total	48	0	0					24.48		7
564879	5555	P7	5	6556558	DATA	9615190000	96159000	HAIR CLIPS		CN	96159000 HAIR CLIPS CN	18			18.00EA	18.00	EA	0.17	3.06	8
564879	5555	P7	7	616047	DATA	9615900000	96159000	HAIR CLIPS		CN	96159000 HAIR CLIPS CN	30			30.00EA	30.00	EA	0.26	7.80	8
											96159000 HAIR CLIPS CN Total	48	0	0					10.86		8
											Grand Total	733	0	0					657.37

<colgroup><col span="5"><col><col><col><col><col><col><col><col span="10"></colgroup><tbody>
</tbody>

summary

Tarif No Description Origin	Qty_1	Litres	Sugar	Qty	QTY	Unit	@	Amount	DETAILS	ITEMISED
09012200 GROUND COFFEE ZA Total	12	0	0					23.16		1
09012100 COFFEE ZA Total	96	0	0					240.96		2
04029100 EVAPORATD MILK DE Total	240	0	0					146.40		3
04022900 CARAMEL TOPPING UA Total	225	0	0					177.75		4
96190040 SANITARY PADS ZA Total	16	0	0					9.76		5
96190040 SANITARY PADS CN Total	48	0	0					24.00		6
96159000 HAIRSLIDES CN Total	48	0	0					24.48		7
96159000 HAIR CLIPS CN Total	48	0	0					10.86		8
Grand Total	733	0	0					657.37

<colgroup><col><col span="5"><col><col><col span="3"></colgroup><tbody>
</tbody>

 

[skywriter]

Cross Posted.