How to split cells in one sheet and copy to another sheet?

Sarathy

New Member
Joined
Nov 11, 2011
Messages
12
Hi I am new to excel.
I need a code for the following scenerio.


In "Sheet_1", I am giving input as follows:

A B C D E
1 Ram Chennai 10/03/1989 a/b/c First
2 Sam Mumbai 12/5/1980 d/e/f Second
3 Kumar Kolkatta 14/8/1999 g/h Third



In "Sheet_2", I need the output as follows:


A B C D E
1 Ram Chennai 10/03/1989 a First
2 Ram Chennai 10/03/1989 b First
3 Ram Chennai 10/03/1989 c First
4 Sam Mumbai 12/5/1980 d Second
5 Sam Mumbai 12/5/1980 e Second
6 Sam Mumbai 12/5/1980 f Second
7 Kumar Kolkatta 14/8/1999 g Third
8 Kumar Kolkatta 14/8/1999 h Third

Note: Only the D column should get splitted, not the C column(Date)

Thanks in advance.

Regards,
Sarathy.
 
Hiker,
The expected result is:

S.No Name Units date TaskName Type SubType

5636 Ram 4 10/2/2011 abc Sample Test
5636 Ram 4 10/2/2011 def Dev def

6265 Sam 5 10/2/2011 ghi Dev ghi

6265 Sam 5 10/2/2011 jkl Dev jkl
1234 Kish 3 10/2/2011 mno

1234 Kish 3 10/2/2011 pqr
1438 John 4 10/2/2011 stu Dev stu

6549 Reena 3 10/2/2011 vwx Sample2 Test2
6549 Reena 3 10/2/2011 yz Dev yz

6784 Thomas 3 10/2/2011 ab

6784 Thomas 3 10/2/2011 cd
6784 Thomas 3 10/2/2011 ef
1416 Shiv 2 10/2/2011 gh Dev gh
1416 Shiv 2 10/2/2011 ij Dev ij


This is the extension of previous scenerio.

earlier, you will match column A of sheet1 and column A of lookup sheet.

Now, if the previous match fails, compare TaskName column with the pattern column of the Sheet"A". Even if it is partially matched, the respective type and subType column should be copied from Sheet"A" to Sheet_1.

Thanks in advance, Hiker.
 
Upvote 0

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Hiker,
Sorry, yesterday i was in a position unable to provide you the screenshot.
Here it is:
<TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=320><COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 30.75pt" height=41><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; HEIGHT: 30.75pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=41 width=64>Column1

</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl68 width=64>Column2</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl68 width=64>Column3</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl68 width=64>Column4</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" class=xl74 width=64>Column5</TD></TR>

The lookup sheet is:
<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2935987 class=xl69 height=21 width=64>Dev</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>Pattern</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>Type</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=64>SubType</TD></TR>


<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2935987 class=xl70 height=21 width=64>1416</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64>no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64>Sample</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=64>Test</TD></TR>





<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl71 height=21 width=64>4263</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>qr</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>Sample2</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=64>Test2</TD></TR>





<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=21 width=64>1438</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=64> </TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2937813 class=xl71 height=21 width=64>5636</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=64> </TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2937813 class=xl70 height=21 width=64>6265</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=64> </TD></TR>





<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl72 height=21 width=64>6549</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl73 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl73 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl73 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl77 width=64>

</TD></TR></TBODY></TABLE>

I want the output as:

<TABLE style="WIDTH: 368pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=491><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><TBODY><TR style="HEIGHT: 30.75pt" height=41><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #666699; HEIGHT: 30.75pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl77 height=41 width=64>S.No
</TD>
<TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>Name</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>Units</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 56pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=75>date</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 66pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=88>Task Name</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>Type</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl66 width=72>Subtype</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl78 height=21 width=64 align=right>5636
</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>Ram</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64 align=right>4</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none">abc</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2935987>abc</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl78 height=21 width=64 align=right>5636
</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>Ram</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64 align=right>4</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none">def</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2935987>def</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6265

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Sam</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>5</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ghi

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>ghi</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6265

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Sam</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>5</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>jkl

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>jkl</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1234

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Kish</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>mno

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl74 width=64>Sample</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=72>Test</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1234

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Kish</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>pqr

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2937813 class=xl73 width=64>Sample2</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=72>Test2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1438

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>John</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>4</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>stu

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>stu</TD></TR>



<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl79 height=21 width=64 align=right>6549

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Reena</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>vwx

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>vwx</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6549

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Reena</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>yz

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>yz</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6784

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Thomas</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ab

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6784

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Thomas</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>cd

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6784

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Thomas</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ef

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1416

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Shiv</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>2</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>gh

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>gh</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1416

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Shiv</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>2</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ij

</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>ij</TD></TR></TBODY></TABLE>


Hope you get this..
Thanks in advance.:)
 
Upvote 0
Hiker,
Sorry, yesterday i was in a position unable to provide you the screenshot.
Here it is:
<TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=320><COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 30.75pt" height=41><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; HEIGHT: 30.75pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=41 width=64>Column1

</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl68 width=64>Column2</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl68 width=64>Column3</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: white 0.5pt solid" class=xl68 width=64>Column4</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" class=xl74 width=64>Column5</TD></TR>

The lookup sheet is:
<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2935987 class=xl69 height=21 width=64>Dev</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>Pattern</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>Type</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=64>SubType</TD></TR>


<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2935987 class=xl70 height=21 width=64>1416</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64>no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64>Sample</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=64>Test</TD></TR>





<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl71 height=21 width=64>4263</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>qr</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64>Sample2</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=64>Test2</TD></TR>





<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=21 width=64>1438</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=64> </TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2937813 class=xl71 height=21 width=64>5636</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl65 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=64> </TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2937813 class=xl70 height=21 width=64>6265</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=64> </TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=64> </TD></TR>





<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl72 height=21 width=64>6549</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl73 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl73 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" class=xl73 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl77 width=64>

</TD></TR></TBODY></TABLE>

I want the output as:

<TABLE style="WIDTH: 368pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=491><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><TBODY><TR style="HEIGHT: 30.75pt" height=41><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #666699; HEIGHT: 30.75pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl77 height=41 width=64>S.No
</TD>
<TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>Name</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>Units</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 56pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=75>date</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 66pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=88>Task Name</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=64>Type</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #666699; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl66 width=72>Subtype</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl78 height=21 width=64 align=right>5636
</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>Ram</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64 align=right>4</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none">abc</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2935987>abc</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl78 height=21 width=64 align=right>5636
</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>Ram</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64 align=right>4</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none">def</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2935987>def</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6265

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Sam</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>5</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ghi

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>ghi</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6265

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Sam</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>5</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>jkl

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>jkl</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1234

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Kish</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>mno

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl74 width=64>Sample</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=72>Test</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1234

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Kish</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>pqr

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: white 0.5pt solid" id=td_post_2937813 class=xl73 width=64>Sample2</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: #b8cce4; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=72>Test2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1438

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>John</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>4</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>stu

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>stu</TD></TR>



<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl79 height=21 width=64 align=right>6549

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Reena</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>vwx

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>vwx</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6549

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Reena</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>yz

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>yz</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6784

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Thomas</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ab

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6784

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Thomas</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>cd

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>6784

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Thomas</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ef

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1416

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Shiv</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>2</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>gh

</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #B8CCE4 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>gh</TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; FONT-FAMILY: Verdana; BACKGROUND: white; HEIGHT: 15.75pt; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #3867a6 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl79 height=21 width=64 align=right>1416

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64>Shiv</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=64 align=right>2</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 56pt; BORDER-TOP: #3867a6; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=75 align=right>10/2/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=88>ij

</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; FONT-FAMILY: Verdana; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; BORDER-RIGHT: #d4d0c8; TEXT-DECORATION: none; mso-pattern: #DBE5F1 none; text-underline-style: none; text-line-through: none" id=td_post_2937813 class=xl72>Dev

</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 54pt; BORDER-TOP: #3867a6; BORDER-RIGHT: #3867a6 1pt solid" id=td_post_2935987 class=xl71 width=72>ij</TD></TR></TBODY></TABLE>


in the above result, you can find sample,sample2 which were taken from the lookup sheet.This is because, the task name column somewhat matches with the pattern column of lookup sheet.

Hope you get this..
Thanks in advance.:)
 
Upvote 0
Sarathy,


Sample raw data worksheet Sheet_1, and worksheet A:


Excel Workbook
ABCDEFG
1S.NoNameUnitsdateTask NameTypeSubtype
25636Ram410/2/2011abc/def
36265Sam510/2/2011ghi/jkl
41234Kish310/2/2011mno/pqr
51438John410/2/2011stu
66549Reena310/2/2011vwx/yz
76784Thomas310/2/2011ab/cd/ef
81416Shiv210/2/2011gh/ij
9
Sheet_1





Excel Workbook
ABCDE
1DevPatternTypeSubType
21416noSampleTest
34263qrSample2Test2
41438
55636
66265
76549
8
A





After the macro in a new worksheet Results:


Excel Workbook
ABCDEFG
1S.NoNameUnitsdateTask NameTypeSubtype
25636Ram410/2/2011abcDevabc
35636Ram410/2/2011defDevdef
46265Sam510/2/2011ghiDevghi
56265Sam510/2/2011jklDevjkl
61234Kish310/2/2011mnoSampleTest
71234Kish310/2/2011pqrSample2Test2
81438John410/2/2011stuDevstu
96549Reena310/2/2011vwxDevvwx
106549Reena310/2/2011yzDevyz
116784Thomas310/2/2011ab
126784Thomas310/2/2011cd
136784Thomas310/2/2011ef
141416Shiv210/2/2011ghDevgh
151416Shiv210/2/2011ijDevij
16
Results





Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.


Code:
Option Explicit
Sub SplitDataV3()
' hiker95, 11/22/2011
' http://www.mrexcel.com/forum/showthread.php?t=592332
Dim w1 As Worksheet, wA As Worksheet, wR As Worksheet
Dim lr As Long, Sp, s As Long, r As Long, fr As Long
Dim P, lp As Long, pp As Long, c As Range, rng As Range
Application.ScreenUpdating = False
Set w1 = Worksheets("Sheet_1")
Set wA = Worksheets("A")
lp = wA.Cells(Rows.Count, 3).End(xlUp).Row
P = wA.Range("C2:E" & lp)
If Not Evaluate("ISREF(Results!A1)") Then Worksheets.Add(After:=wA).Name = "Results"
Set wR = Worksheets("Results")
wR.UsedRange.Clear
lr = w1.Cells(Rows.Count, 1).End(xlUp).Row
w1.Range("A1").Resize(lr, 7).Copy wR.Range("A1").Resize(lr, 7)
For r = lr To 2 Step -1
  If InStr(wR.Cells(r, 5), "/") = 0 Then
    fr = 0
    On Error Resume Next
    fr = Application.Match(wR.Cells(r, 1), wA.Columns(1), 0)
    On Error GoTo 0
    If fr = 0 Then
      Set rng = wR.Cells(r, 5).Resize(s + 1)
      For Each c In rng
        For pp = LBound(P) To UBound(P)
          If InStr(c, P(pp, 1)) > 0 Then
            c.Offset(, 1) = P(pp, 2)
            c.Offset(, 2) = P(pp, 3)
          End If
        Next pp
      Next c
    Else
      wR.Cells(r, 6) = "Dev"
      wR.Cells(r, 7) = wR.Cells(r, 5)
    End If
  ElseIf InStr(wR.Cells(r, 5), "/") > 0 Then
    Sp = Split(wR.Cells(r, 5), "/")
    s = UBound(Sp)
    wR.Rows(r).Offset(1).Resize(UBound(Sp)).Insert
    wR.Rows(r).Copy wR.Rows(r).Offset(1).Resize(UBound(Sp))
    wR.Cells(r, 5).Resize(s + 1) = Application.Transpose(Sp)
    fr = 0
    On Error Resume Next
    fr = Application.Match(wR.Cells(r, 1), wA.Columns(1), 0)
    On Error GoTo 0
    If fr = 0 Then
      Set rng = wR.Cells(r, 5).Resize(s + 1)
      For Each c In rng
        For pp = LBound(P) To UBound(P)
          If InStr(c, P(pp, 1)) > 0 Then
            c.Offset(, 1) = P(pp, 2)
            c.Offset(, 2) = P(pp, 3)
          End If
        Next pp
      Next c
    Else
      wR.Cells(r, 6).Resize(s + 1) = "Dev"
      wR.Cells(r, 7).Resize(s + 1) = Application.Transpose(Sp)
    End If
  End If
Next r
wR.UsedRange.Columns.AutoFit
wR.Activate
Erase P
Application.ScreenUpdating = True
End Sub


Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm


Then run the SplitDataV3 macro.
 
Upvote 0

Forum statistics

Threads
1,223,711
Messages
6,174,020
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top