Appendix Thread 2. ( Codes for other Threads, HTML Tables, etc.)

[DocAElstein]

From last Post... master File After Distribition and before Consolidation
File: “zMasterBeforeConsolidation.xlsm”
https://app.box.com/s/818q2ev3owpini2202n3dqp3xxicfeif

S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member	Checked
1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
2	ABC02	$ 13.66	7	$ 95.62	02.Apr.2018								John
3	ABC03	$ 12.99	5	$ 64.95	02.Apr.2018								Greg
4	ABC04	$ 8.51	12	$ 102.12	02.Apr.2018								Margaret
5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
6	ABC06	$ 3.99	35	$ 139.65	02.Apr.2018								John
7	ABC07	$ 333.45	99	$ 33,011.55	02.Apr.2018								Greg
8	ABC08	$ 11.99	1	$ 11.99	02.Apr.2018								Margaret
9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu
10	ABC10	$ 55.00	22	$ 1,210.00	02.Apr.2018								John
11	ABC11	$ 13.66	7	$ 95.62	02.Apr.2018								Greg
12	ABC12	$ 12.99	5	$ 64.95	02.Apr.2018								Margaret
13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018								Raghu
14	ABC14	$ 7.22	62	$ 447.64	02.Apr.2018								John
15	ABC15	$ 3.99	35	$ 139.65	02.Apr.2018								Greg
16	ABC16	$ 333.45	99	$ 33,011.55	02.Apr.2018								Margaret
17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018								Raghu
18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018								John
19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018								Greg
20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018								Margaret
21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018								John
23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018								Greg
24	ABC24	$ 3.99	35	$ 139.65	02.Apr.2018								Margaret
25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
26	ABC26	$ 11.99	1	$ 11.99	02.Apr.2018								John
27	ABC27	$ 741.99	101	$ 74,940.99	02.Apr.2018								Greg
28	ABC28	$ 55.00	22	$ 1,210.00	02.Apr.2018								Margaret
29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
30	ABC30	$ 12.99	5	$ 64.95	02.Apr.2018								John
31	ABC31	$ 8.51	12	$ 102.12	02.Apr.2018								Greg
32	ABC32	$ 7.22	62	$ 447.64	02.Apr.2018								Margaret
33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
34	ABC34	$ 333.45	99	$ 33,011.55	02.Apr.2018								John
35	ABC35	$ 11.99	1	$ 11.99	02.Apr.2018								Greg
36	ABC36	$ 741.99	101	$ 74,940.99	02.Apr.2018								Margaret
37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
38	ABC38	$ 13.66	7	$ 95.62	02.Apr.2018								John
39	ABC39	$ 12.99	5	$ 64.95	02.Apr.2018								Greg
40	ABC40	$ 8.51	12	$ 102.12	02.Apr.2018								Margaret
41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
42	ABC42	$ 3.99	35	$ 139.65	02.Apr.2018								John
43	ABC43	$ 333.45	99	$ 33,011.55	02.Apr.2018								Greg
44	ABC44	$ 11.99	1	$ 11.99	02.Apr.2018								Margaret
45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu

Worksheet: OriginalData