Data Validation

[youcefme]

<TABLE style="WIDTH: 421pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=562 border=0><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 173pt; mso-width-source: userset; mso-width-alt: 8448" width=231><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 287pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" width=383 colSpan=3 height=20>Hi, I would appreciate if any one came help me .</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 86pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=115></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" colSpan=3 height=20>I have this table of staff leave </TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: white" height=20>Ref</TD><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white">Date</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white">Name</TD><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white">Nature</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>NH0110-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">5-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Budi</TD><TD class=xl75 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Annual Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>AZ0110-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">11-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Sabil</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Annual Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>JA0110-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">12-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Low</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Annual Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl77 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>BS0110-1</TD><TD class=xl78 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">13-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">JAY</TD><TD class=xl79 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Unpaid Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>SM0110-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">19-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Pat</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Annual Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>ZM0110-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">19-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Budi</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Medical Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>JA0110-2</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">26-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">JAY</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Annual Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>MF0110-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">26-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Low</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Emergency Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>NS0110-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">26-Jan-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">JAY</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Annual Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>AZ0210-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">2-Feb-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Low</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Annual Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>NR0210-1</TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">2-Feb-10</TD><TD class=xl74 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Sabil</TD><TD class=xl76 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent">Unpaid Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl80 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #4f81bd 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>BS0210-1</TD><TD class=xl81 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #4f81bd 0.5pt solid; BACKGROUND-COLOR: transparent">5-Feb-10</TD><TD class=xl82 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #4f81bd 0.5pt solid; BACKGROUND-COLOR: transparent">Budi</TD><TD class=xl83 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #4f81bd 0.5pt solid; BACKGROUND-COLOR: transparent">Unpaid Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" colSpan=5 height=20>I want to have a dropdown list with data validation that shows ref of annual leave only .</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan" colSpan=2 height=20>Annuel Leave</TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: white" height=20>Ref</TD><TD class=xl69 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: white">Name </TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"> </TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"> </TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"> </TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl71 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"> </TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl72 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd 0.5pt solid; BORDER-BOTTOM: #4f81bd 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl73 style="BORDER-RIGHT: #4f81bd 0.5pt solid; BORDER-TOP: #4f81bd 0.5pt solid; BORDER-LEFT: #4f81bd; BORDER-BOTTOM: #4f81bd 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>

 

[Andrew Poulsom]

Say your data is in the range A1:D13 on Sheet1. In E2 enter:

=IF(D2="Annual Leave",ROW(),"")

and copy down. In F2 enter:

=IF(ROW(A1)-ROW(A$1)+1>COUNT(E$2:E$13),"",INDEX(A:A,SMALL(E$2:E$13,1+ROW(A1)-ROW(A$1))))

and copy down. Choose Insert|Name|Define. In the Names box enter AnnualLeave and in the Refers to box enter:

=OFFSET(Sheet1!$F$2,0,0,COUNTA(Sheet1!$F$2:$F$13)-COUNTBLANK(Sheet1!$F$2:$F$13),1)

and click Add then Close. Now set up Data Validation with Allow List, Source =AnnualLeave.

 

[baitmaster]

not sure I fully understand the question, but I think you want Autofilter, not Data > Validation

Select your data table
XL2003 - Data > Filter > Autofilter
XL2007 - Data > Filter

But if you want a Data > Validation list, of only those Annual Leave records, then you will probably need to use VBA - I think you need to loop through your source data, extract values that meet your criteria, and add them to a new list - which is the Data Validation lookup list. I'm not sure of an easy way to do what you want using just data validation without VBA