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

[DocAElstein]

Typical Updated Data File, "Raghu.xlsx" after first consolidation,
with the column L updated appropriately with the consolidation date



Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018		Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu
14

Worksheet: Tabelle1

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=320960#p320960
https://eileenslounge.com/viewtopic.php?p=320957#p3209573
https://eileenslounge.com/viewtopic.php?p=318868#p318868
https://eileenslounge.com/viewtopic.php?p=318311#p318311
https://eileenslounge.com/viewtopic.php?p=318302#p318302
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317857#p317857
https://eileenslounge.com/viewtopic.php?p=317541#p317541
https://eileenslounge.com/viewtopic.php?p=317520#p317520
https://eileenslounge.com/viewtopic.php?p=317510#p317510
https://eileenslounge.com/viewtopic.php?p=317547#p317547
https://eileenslounge.com/viewtopic.php?p=317573#p317573
https://eileenslounge.com/viewtopic.php?p=317574#p317574
https://eileenslounge.com/viewtopic.php?p=317582#p317582
https://eileenslounge.com/viewtopic.php?p=317583#p317583
https://eileenslounge.com/viewtopic.php?p=317605#p317605
https://eileenslounge.com/viewtopic.php?p=316935#p316935
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317014#p317014
https://eileenslounge.com/viewtopic.php?p=316940#p316940
https://eileenslounge.com/viewtopic.php?p=316927#p316927
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[DocAElstein]

Run Code Sub ExportByName() on data from last post

Results for Updated master Worksheet

Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
25	24	ABC24	$ 3.99	35	$ 139.65	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
26	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
27	26	ABC26	$ 11.99	1	$ 11.99	02.Apr.2018								John
28	27	ABC27	$ 741.99	101	$ 74,940.99	02.Apr.2018								Greg
29	28	ABC28	$ 55.00	22	$ 1,210.00	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
30	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
31	30	ABC30	$ 12.99	5	$ 64.95	02.Apr.2018								John
32	31	ABC31	$ 8.51	12	$ 102.12	02.Apr.2018								Greg
33	32	ABC32	$ 7.22	62	$ 447.64	02.Apr.2018								Margaret
34	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
35	34	ABC34	$ 333.45	99	$ 33,011.55	02.Apr.2018								John
36	35	ABC35	$ 11.99	1	$ 11.99	02.Apr.2018								Greg
37	36	ABC36	$ 741.99	101	$ 74,940.99	02.Apr.2018								Margaret
38	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
39	38	ABC38	$ 13.66	7	$ 95.62	02.Apr.2018								John
40	39	ABC39	$ 12.99	5	$ 64.95	02.Apr.2018								Greg
41	40	ABC40	$ 8.51	12	$ 102.12	02.Apr.2018								Margaret
42	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
43	42	ABC42	$ 3.99	35	$ 139.65	02.Apr.2018								John
44	43	ABC43	$ 333.45	99	$ 33,011.55	02.Apr.2018								Greg
45	44	ABC44	$ 11.99	1	$ 11.99	02.Apr.2018								Margaret
46	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu
47	46	ABC46	$ 8.51	12	$ 102.12	02.Apr.2018								John
48	47	ABC47	$ 7.22	62	$ 447.64	02.Apr.2018								Greg
49	48	ABC48	$ 3.99	35	$ 139.65	02.Apr.2018								Margaret
50	49	ABC49	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
51	50	ABC50	$ 11.99	1	$ 11.99	02.Apr.2018								Raghu
52
53
54

Worksheet: OriginalData