Appendix Thread. ( Codes for other Threads, etc.) Event Coding Drpdown Data validation

[DocAElstein]

Final results for first half of master File after second consolidation

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	Checked
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
3	2	ABC02	$ 13.66	7	$ 95.62	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
4	3	ABC03	$ 12.99	5	$ 64.95	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
5	4	ABC04	$ 8.51	12	$ 102.12	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
6	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
7	6	ABC06	$ 3.99	35	$ 139.65	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
8	7	ABC07	$ 333.45	99	$ 33,011.55	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
9	8	ABC08	$ 11.99	1	$ 11.99	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
10	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
11	10	ABC10	$ 55.00	22	$ 1,210.00	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
12	11	ABC11	$ 13.66	7	$ 95.62	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
13	12	ABC12	$ 12.99	5	$ 64.95	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
14	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
15	14	ABC14	$ 7.22	62	$ 447.64	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
16	15	ABC15	$ 3.99	35	$ 139.65	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
17	16	ABC16	$ 333.45	99	$ 33,011.55	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
18	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
19	18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
20	19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
21	20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
22	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
23	22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
24	23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
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	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu

Worksheet: OriginalData