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