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

[DocAElstein]

follow on from last post:

Before

the final result is in missing data sheet plz see
missing data sheet already has data and we have pasted the result below that data(the data starts with A2 is the result)
A1 in missing data sheet already has data so we putted the result below that plz see sir

_____ Workbook: VBA Before.xls ( Using Excel 2007 32 bit )

Row\Col	A	B
1	11111158
2
3
4

Worksheet: Missing data
_____ Workbook: VBA Before.xls ( Using Excel 2007 32 bit )

Row\Col	A	B
1	1234
2	5678
3	91011
4	12131415
5	1617181920
6

Worksheet: abc
_____ Workbook: VBA Before.xls ( Using Excel 2007 32 bit )

Row\Col	A	B	C
1	1234
2	15678
3	191011
4	112131415
5	16171811920		after the process completed delete all the data in this sheet

Worksheet: def
_____ Workbook: VBA Before.xls ( Using Excel 2007 32 bit )

Row\Col	A	B
1	115678
2	191011
3	1112131415
4	1.16172E+11
5

Worksheet: Fake Data
_____ Workbook: VBA Before.xls ( Using Excel 2007 32 bit )

Row\Col	A	B
1	115678
2

Worksheet: Completed
_____ Workbook: VBA Before.xls ( Using Excel 2007 32 bit )

Row\Col	A	B
1	11111158
2
3
4

Worksheet: Missing data