Vlookup in an array

spiderjolly

Board Regular
Joined
Oct 20, 2009
Messages
58
Hi Iam trying to make a drop down list based on the result of a vlookup.
What i want to do is look into a table that has country name, depot station, but i have more than one depot per country so when i look up with vlookup i only get one result back, the table looks like this.
<TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=320 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17> </TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64> Country </TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64> Country name</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Depot code </TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Depot name </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 1</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> GB</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">United Kingdom </TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> STN</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> Stansted</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 2</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> GB</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">United Kingdom </TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> EDI</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> Edinburgh</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 3</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> GB</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> United Kingdom</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> EMA</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> East midlands</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 4</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> FR</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> France
</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> GNO</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> Garanoa</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 5</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> FR</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> France</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> MRS</TD><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> Marseille</TD></TR></TBODY></TABLE>
How can i look up GB or United Kingdom and get all the depots listed from that country. Can anyone help please.
 
Hi
Here is a screen shot of what i am trying to achieve. If I enter the region code in the top drop down box then the next drop down box should only be able to list the coutries in that region, then once the country has been selected the next box should only be able to list the depots from that country. Then final i want the address to be populated once the depot is selected.
<TABLE style="WIDTH: 357pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=474 border=0 x:str><COLGROUP><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 20pt; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=26 height=20></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 38pt; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" width=50></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 59pt; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" width=78></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 48pt; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 48pt; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 48pt; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 48pt; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" width=64></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 48pt; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" width=64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" vAlign=top align=left height=20><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:rect id=Rectangle_x0020_2 style="MARGIN-TOP: 0.75pt; Z-INDEX: 1; VISIBILITY: visible; MARGIN-LEFT: 0px; WIDTH: 356.25pt; POSITION: absolute; HEIGHT: 22.5pt; v-text-anchor: middle" stroked="f" fillcolor="#f90 [52]" o:spid="_x0000_s36865"><v:fill rotate="t" color2="#048fc2"></v:fill><v:shadow opacity="29491f" offset=".74836mm,.74836mm" origin="-.5,-.5" color="#17375e" on="t"></v:shadow><v:textbox style="mso-direction-alt: auto; mso-rotate-with-shape: t">
Location details
</v:textbox><?xml:namespace prefix = x ns = "urn:schemas-microsoft-com:eek:ffice:excel" /><x:ClientData ObjectType="Rect"><x:MoveWithCells></x:MoveWithCells><x:SizeWithCells></x:SizeWithCells><x:TextVAlign>Center</x:TextVAlign> </x:ClientData></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 20pt; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=26 height=20></TD></TR></TBODY></TABLE></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl71 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl72 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD><TD class=xl72 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD><TD style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent" vAlign=top align=left><v:shapetype id=_x0000_t201 path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:path o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"></v:path><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:lock shapetype="t" v:ext="edit"></o:lock></v:shapetype><v:shape id=_x0000_s36869 style="MARGIN-TOP: 12.75pt; Z-INDEX: 5; MARGIN-LEFT: 2.25pt; WIDTH: 186pt; POSITION: absolute; HEIGHT: 15.75pt" stroked="f" o:insetmode="auto" strokecolor="windowText [64]" type="#_x0000_t201"><o:lock v:ext="edit" text="t" rotation="t"></o:lock></v:shape>
clip_image002.gif
<TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl72 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #f5f4eb; WIDTH: 48pt; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=64 height=20> </TD></TR></TBODY></TABLE></TD><TD class=xl72 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD><TD class=xl72 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD><TD class=xl72 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD><TD class=xl73 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent">Region:</TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent">Country:</TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 192pt; BORDER-BOTTOM: #f5f4eb; HEIGHT: 30pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan-rowspan" width=256 colSpan=4 height=40 rowSpan=2><v:shape id=_x0000_s36868 style="MARGIN-TOP: 0px; Z-INDEX: 4; MARGIN-LEFT: 2.25pt; WIDTH: 186pt; POSITION: absolute; HEIGHT: 15.75pt" stroked="f" o:insetmode="auto" strokecolor="windowText [64]" type="#_x0000_t201"><o:lock v:ext="edit" text="t" rotation="t"></o:lock></v:shape>
clip_image002.gif
</TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent">Location:</TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; WIDTH: 192pt; BORDER-BOTTOM: #f5f4eb; HEIGHT: 30pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan-rowspan" width=256 colSpan=4 height=40 rowSpan=2><v:shape id=_x0000_s36870 style="MARGIN-TOP: 2.25pt; Z-INDEX: 6; MARGIN-LEFT: 1.5pt; WIDTH: 186pt; POSITION: absolute; HEIGHT: 15.75pt" stroked="f" o:insetmode="auto" strokecolor="windowText [64]" type="#_x0000_t201"><o:lock v:ext="edit" text="t" rotation="t"></o:lock></v:shape>
clip_image002.gif
</TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl77 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl93 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" colSpan=4> </TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl77 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl76 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent">Address:</TD><TD class=xl86 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: silver" colSpan=4> </TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl78 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl79 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent">City:</TD><TD class=xl89 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: silver" colSpan=4> </TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl78 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl79 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent">Post. code:</TD><TD class=xl92 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: silver" colSpan=4> </TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #f5f4eb; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl78 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"></TD><TD class=xl75 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #f5f4eb; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl80 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #0066cc 0.5pt solid; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl81 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl82 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl81 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl81 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl81 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl81 style="BORDER-RIGHT: #f5f4eb; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl83 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #f5f4eb; BORDER-LEFT: #f5f4eb; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR></TBODY></TABLE>

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Where to upload Excel files so threads don't take 20+ posts to get the correct answer from guessing:
MediaFire: http://www.mediafire.com/
FileFactory: http://www.filefactory.com/
FileSavr: http://www.filesavr.com/
FileDropper: http://www.filedropper.com/
Or, you can upload it to www.box.net and provide us with a link to your workbook.[/QUOTE]
 
Upvote 0

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,214,561
Messages
6,120,245
Members
448,952
Latest member
kjurney

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