Handling data macro

B

blab

New Member
Joined
Dec 27, 2011
Messages
20
Hello,

I am trying to write a macro that searches for different words within a colomn. If the word exists, I would like to copy the rows of the 2nd and 3rd hit to a new worksheet.

It would look like this:
Possible words that could be present: a, b, c, d, e.
2 options: If a word is found, it is present three times. If not found, not present at all.

In case it is found, I would like to have the first 6 cells of the corresponding row copied to another worksheet.
i.e.: second hit of 'a' copy cells to the next empty row in a different worksheet to specific columns.

Examples:
Input:
Rich (BB code): 
<TABLE style="WIDTH: 778pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1036 x:str><COLGROUP><COL style="WIDTH: 153pt; mso-width-source: userset; mso-width-alt: 7460" width=204><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 5485" width=150><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5083" width=139><COL style="WIDTH: 114pt; mso-width-source: userset; mso-width-alt: 5558" width=152><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><TBODY><TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 153pt; HEIGHT: 31.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 height=42 width=204><!-- TABLEDEF--><!-- header row -->Description</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 47pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 width=63>Ccy</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=150>Portfolio MV Ultimo</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 104pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=139>Portfolio Weight Ultimo</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=152>Benchmark Weight Ultimo</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; WIDTH: 66pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=88></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=85></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=94></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; WIDTH: 46pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=61></TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26 height=17>Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 x:num="1.44367121">1.44367121</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.2599999999999999E-2">2.26%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26 height=17>Fixed Income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 x:num="62.435242760000001">62.43524276</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0.97740000000000005">97.74%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="1">100.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><!--PARENT--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl29 height=17>Total<\b></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 x:num="63.878913969999999">63.87891397</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="1">100.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="1">100.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 153pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 height=17 width=204></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=63></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=150></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=139></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=152></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffffff; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><!-- TABLEDEF--><!-- header row --><TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 153pt; HEIGHT: 31.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 height=42 width=204>Description</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 47pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 width=63>Ccy</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=150>Portfolio Return MTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 104pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=139>Benchmark Return MTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=152>Excess Return MTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 66pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=88>Allocation MTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=85>Selection MTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=94>Interaction MTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 46pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=61>Total MTD</TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26 height=17>Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.0000000000000001E-4">0.02%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.0000000000000001E-4">0.02%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26 height=17>Fixed Income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.0999999999999996E-3">0.81%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-2.9999999999999997E-4">-0.03%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.3000000000000001E-3">0.83%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.3000000000000001E-3">0.83%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-2.0000000000000001E-4">-0.02%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.0999999999999996E-3">0.81%</TD></TR><!--PARENT--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl29 height=17>Total<\b></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="7.9000000000000008E-3">0.79%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-2.9999999999999997E-4">-0.03%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.2000000000000007E-3">0.82%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.3000000000000001E-3">0.83%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-2.0000000000000001E-4">-0.02%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.2000000000000007E-3">0.82%</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 153pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 height=17 width=204></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=63></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=150></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=139></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=152></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=88></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=85></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=94></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 46pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=61></TD></TR><!-- TABLEDEF--><!-- header row --><TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 153pt; HEIGHT: 31.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 height=42 width=204>Description</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 47pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 width=63>Ccy</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=150>Portfolio Return 3M</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 104pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=139>Benchmark Return 3M</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=152>Excess Return 3M</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 66pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=88>Allocation 3M</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=85>Selection 3M</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=94>Interaction 3M</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #333399; WIDTH: 46pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl25 width=61>Total 3M</TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl32 height=17>Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="5.9999999999999995E-4">0.06%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="5.9999999999999995E-4">0.06%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-5.0000000000000001E-4">-0.05%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-4.0000000000000002E-4">-0.04%</TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl32 height=17>Fixed Income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.23E-2">2.23%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0.02">2.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.3E-3">0.23%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.3E-3">0.23%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-1E-4">-0.01%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.3E-3">0.23%</TD></TR><!--PARENT--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl33 height=17>Total<\b></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.18E-2">2.18%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0.02">2.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="1.8E-3">0.18%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-5.0000000000000001E-4">-0.05%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="2.3E-3">0.23%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="1.8E-3">0.18%</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 153pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 height=17 width=204></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=63></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=150></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 104pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=139></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=152></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=88></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=85></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=94></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 46pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl30 width=61></TD></TR><!-- TABLEDEF--><!-- header row --><TR style="HEIGHT: 31.5pt; mso-height-source: userset" height=42><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 153pt; HEIGHT: 31.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 height=42 width=204>Description</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #003366; WIDTH: 47pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl24 width=63>Ccy</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 113pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=150>Portfolio Return YTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 104pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=139>Benchmark Return YTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=152>Excess Return YTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 66pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=88>Allocation YTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=85>Selection YTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=94>Interaction YTD</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #00ccff; WIDTH: 46pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 1pt solid" class=xl31 width=61>Total YTD</TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl32 height=17>Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.0000000000000004E-4">0.08%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="8.0000000000000004E-4">0.08%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-8.9999999999999998E-4">-0.09%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-8.9999999999999998E-4">-0.09%</TD></TR><!--CHILD--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl32 height=17>Fixed Income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="3.5299999999999998E-2">3.53%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="3.9899999999999998E-2">3.99%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-4.4999999999999997E-3">-0.45%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="0">0.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-4.4999999999999997E-3">-0.45%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="1E-4">0.01%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-4.4000000000000003E-3">-0.44%</TD></TR><!--PARENT--><TR style="HEIGHT: 12.75pt" height=17 memvis="TRUE"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl33 height=17>Total<\b></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl26>EUR</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="3.4500000000000003E-2">3.45%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="3.9899999999999998E-2">3.99%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-5.3E-3">-0.53%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-8.9999999999999998E-4">-0.09%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-4.4999999999999997E-3">-0.45%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="1E-4">0.01%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: silver; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 x:num="-5.3E-3">-0.53%</TD></TR></TBODY></TABLE>

Output:
Rich (BB code): 
<TABLE style="WIDTH: 3513pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=4679 x:str><COLGROUP><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 116pt; mso-width-source: userset; mso-width-alt: 5668" width=155><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6363" width=174><COL style="WIDTH: 114pt; mso-width-source: userset; mso-width-alt: 5558" width=152><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><COL style="WIDTH: 153pt; mso-width-source: userset; mso-width-alt: 7460" width=204><COL style="WIDTH: 168pt; mso-width-source: userset; mso-width-alt: 8192" width=224><COL style="WIDTH: 151pt; mso-width-source: userset; mso-width-alt: 7350" width=201><COL style="WIDTH: 128pt; mso-width-source: userset; mso-width-alt: 6253" width=171><COL style="WIDTH: 126pt; mso-width-source: userset; mso-width-alt: 6144" width=168><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6363" width=174><COL style="WIDTH: 106pt; mso-width-source: userset; mso-width-alt: 5156" width=141><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 5924" width=162><COL style="WIDTH: 137pt; mso-width-source: userset; mso-width-alt: 6656" width=182><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5814" width=159><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" width=129><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4608" width=126><COL style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4827" width=132><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 159pt; mso-width-source: userset; mso-width-alt: 7753" width=212><COL style="WIDTH: 173pt; mso-width-source: userset; mso-width-alt: 8448" width=231><COL style="WIDTH: 157pt; mso-width-source: userset; mso-width-alt: 7643" width=209><COL style="WIDTH: 134pt; mso-width-source: userset; mso-width-alt: 6546" width=179><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6400" width=175><COL style="WIDTH: 137pt; mso-width-source: userset; mso-width-alt: 6656" width=182><COL style="WIDTH: 111pt; mso-width-source: userset; mso-width-alt: 5412" width=148><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 47pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=62>NAME</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=71>Period</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 116pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=155>Portfolio Return 3M Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 131pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=174>Benchmark Return 3M Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 114pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=152>Excess Return 3M Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 92pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=122>Allocation 3M Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 89pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=118>Selection 3M Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 94pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=125>Interaction 3M Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=92>Total 3M Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 153pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=204>Portfolio Return 3M Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 168pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=224>Benchmark Return 3M Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 151pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=201>Excess Return 3M Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 128pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=171>Allocation 3M Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 126pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=168>Selection 3M Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 131pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=174>Interaction 3M Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 106pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=141>Total 3M Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 122pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=162>Portfolio Return YTD Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 137pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=182>Benchmark Return YTD Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 119pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=159>Excess Return YTD Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 97pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=129>Allocation YTD Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 95pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=126>Selection YTD Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 99pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=132>Interaction YTD Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=99>Total YTD Cash</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 159pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=212>Portfolio Return YTD Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 173pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=231>Benchmark Return YTD Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 157pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=209>Excess Return YTD Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 134pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=179>Allocation YTD Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 131pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=175>Selection YTD Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 137pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=182>Interaction YTD Fixed income</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 111pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=148>Total YTD Fixed income</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>CLIENT X</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 align=right x:num="41029">30/04/2012</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="5.9999999999999995E-4">0.0006</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="5.9999999999999995E-4">0.0006</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-5.0000000000000001E-4">-0.0005</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-4.0000000000000002E-4">-0.0004</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="2.23E-2">0.0223</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0.02</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="2.3E-3">0.0023</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="2.3E-3">0.0023</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-1E-4">-0.0001</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="2.3E-3">0.0023</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="8.0000000000000004E-4">0.0008</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="8.0000000000000004E-4">0.0008</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-8.9999999999999998E-4">-0.0009</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-8.9999999999999998E-4">-0.0009</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="3.5299999999999998E-2">0.0353</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="3.9899999999999998E-2">0.0399</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-4.4999999999999997E-3">-0.0045</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num>0</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-4.4999999999999997E-3">-0.0045</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="1E-4">0.0001</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" align=right x:num="-4.4000000000000003E-3">-0.0044</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17>CLIENT Y</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 align=right x:num="41029">30/04/2012</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR></TBODY></TABLE>

Do you have any idea what would be the fast way to write a macro for this?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
858
gvsumich
G
E
  • Question
VBA for Web Scraping help
Replies
0
Views
609
epactheactor
E
V
  • Question
Issue with scraping with VBA
Replies
1
Views
530
John_w
J
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,215,695
Messages
6,126,263
Members
449,307
Latest member
Andile

Share this page

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