Show only filtered value & reference to data validation listbox

jamshoot

Board Regular
Joined
Oct 15, 2009
Messages
198
Hi

I've a Suppliers' Zone data in Sheet2. And a Suppliers' Contact List in Sheet3.

In Sheet1, I've created 3 simple steps for user to get what info. they want quickly.

Step1: In cell A6, I've a validation list which allow user to select the item they want to filter zone (North South East & West).
Step 2: I have a button in cell A9 for user to click & activate the filtered macro after Step 1.The filtered data will then shown in Sheet1 cell A12 to F12.
Step3: The User will then choose which Supplier they want to contact by
select from the Validation List in A15. I've a match & Vlookup formula in A18 to D18 which display the information extract from Sheet3.

The macro is quite straight forward hence I did not show here.
What I want is looking at a better way to make it more simpler. I hope
to get a better suggestion here.
One wild idea I have in mind (which I do not know how) ... is after the filtering, the user can directly place the cursor over at any supplier & a pop-up information hover over the cell showing the contact.
This way, if the user intend to check another supplier, he can move to the next supplier & the information display pop-up.
Anyone ?

Cheers


<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border="0" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 48px"> <col style="WIDTH: 86px"> <col style="WIDTH: 86px"> <col style="WIDTH: 70px"> <col style="WIDTH: 41px"> <col style="WIDTH: 41px"> <col style="WIDTH: 35px"> <col style="WIDTH: 41px"> <col style="WIDTH: 41px"> <col style="WIDTH: 41px"> <col style="WIDTH: 41px"> <col style="WIDTH: 41px"> <col style="WIDTH: 19px"> <col style="WIDTH: 36px"> <col style="WIDTH: 84px"> <col style="WIDTH: 84px"> <col style="WIDTH: 84px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td> <td>I</td> <td>J</td> <td>K</td> <td>L</td> <td>M</td> <td>N</td> <td>O</td> <td>P</td> <td>Q</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="BACKGROUND-COLOR: #000000; FONT-FAMILY: Arial Narrow; COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Sheet1</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BACKGROUND-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; COLOR: #ffffff; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold">Sheet2</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BACKGROUND-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; COLOR: #ffffff; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold">Sheet3</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline" colspan="2">Suppliers' Zone Check List</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Zone</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier1</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier2</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier3</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier4</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier5</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Contact No</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Fax No</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Email</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">North</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">A</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">E</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">J</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">N</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">R</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">A</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Step 1</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">South</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">B</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">F</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">K</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">O</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">S</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">B</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial Narrow; COLOR: #ff0000; FONT-SIZE: 8pt" colspan="2">Please select the zone area</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">East</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">C</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">G</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">L</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">P</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">T</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">C</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">East</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">West</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">D</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">H</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">M</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Q</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">U</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">D</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Step 2</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">E</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial Narrow; COLOR: #ff0000; FONT-SIZE: 8pt" colspan="2">Click below button to get data</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">F</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 1px solid; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Filter Button</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">G</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold">Data</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">H</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-RIGHT: #000000 1px solid">Zone</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier1</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier2</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier3</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier4</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Supplier5</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">J</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-RIGHT: #000000 1px solid">East</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">C</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">G</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">L</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">P</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">T</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">K</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Step 3</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">L</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</td> <td style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial Narrow; COLOR: #ff0000; FONT-SIZE: 8pt" colspan="2">Input Supplier Code</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">M</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">L</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">N</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">O</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-RIGHT: #000000 1px solid">Supplier</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Contact No</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Fax No</td> <td style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Email</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">P</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-RIGHT: #000000 1px solid">L</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">Q</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">R</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">S</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">T</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr> <tr style="HEIGHT: 17px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="FONT-FAMILY: Arial Narrow; FONT-SIZE: 8pt">
</td> <td style="BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">U</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">XXXX XXXX</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Arial Narrow; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">YYYY YYYY</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">z@zzz.com</td></tr></tbody></table>
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,122,564
Messages
5,596,875
Members
414,106
Latest member
Tigretto

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
Top