Vlookup with macro with range on 2 worksheet

F

Fandi

New Member
Joined
Dec 11, 2008
Messages
11
How to create macro vlookup with range based on 2 worksheet...

Let's say : In one file, i have 3 sheets.
1. the form i want fill with data form sheet 2 and sheet 3
2. the data source part1
3. the data source part2

sheet 1
<table x:str="" style="border-collapse: collapse; width: 720pt;" border="0" cellpadding="0" cellspacing="0" width="957"><col style="width: 81pt;" width="108"> <col style="width: 76pt;" width="101"> <col style="width: 80pt;" width="106"> <col style="width: 21pt;" width="28"> <col style="width: 40pt;" span="2" width="53"> <col style="width: 32pt;" span="2" width="43"> <col style="width: 79pt;" width="105"> <col style="width: 29pt;" width="39"> <col style="width: 38pt;" width="50"> <col style="width: 17pt;" width="22"> <col style="width: 32pt;" width="42"> <col style="width: 63pt;" width="84"> <col style="width: 20pt;" width="27"> <col style="width: 40pt;" width="53"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 81pt;" height="17" width="108">
</td> <td style="width: 76pt;" width="101">
</td> <td style="width: 80pt;" width="106">
</td> <td style="width: 21pt;" width="28">
</td> <td style="width: 40pt;" width="53">
</td> <td style="width: 40pt;" width="53">
</td> <td style="width: 32pt;" width="43">
</td> <td style="width: 32pt;" width="43">
</td> <td style="width: 79pt;" width="105">
</td> <td style="width: 29pt;" width="39">
</td> <td style="width: 38pt;" width="50">
</td> <td style="width: 17pt;" width="22">
</td> <td style="width: 32pt;" width="42">
</td> <td style="width: 63pt;" width="84">
</td> <td style="width: 20pt;" width="27">
</td> <td style="width: 40pt;" width="53">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" id="_x0000_s1029" x:autofilter="all" x:autofilterrange="$A$2:$P$19" style="height: 12.75pt;" height="17">Code</td> <td class="xl27" id="_x0000_s1030" x:autofilter="all" style="border-left: medium none;">Customer Name</td> <td class="xl27" id="_x0000_s1031" x:autofilter="all" style="border-left: medium none;">Address</td> <td class="xl27" id="_x0000_s1032" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s1033" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s1034" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s1035" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s1036" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s1037" x:autofilter="all" style="border-left: medium none;">Kecamatan</td> <td class="xl27" id="_x0000_s1038" x:autofilter="all" style="border-left: medium none;">Rayon</td> <td class="xl27" id="_x0000_s1039" x:autofilter="all" style="border-left: medium none;">Class</td> <td class="xl27" id="_x0000_s1040" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s1041" x:autofilter="all" style="border-left: medium none;">Divisi</td> <td class="xl27" id="_x0000_s1042" x:autofilter="all" style="border-left: medium none;">KODESLS</td> <td class="xl27" id="_x0000_s1043" x:autofilter="all" style="border-left: medium none;">TO</td> <td class="xl27" id="_x0000_s1044" x:autofilter="all" style="border-left: medium none;">JO</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000002</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505069</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000002</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505069</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000003</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505070</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000003</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505070</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000003</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505070</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000003</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505070</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000003</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505070</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000005</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505072</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000006</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505073</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000007</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505074</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000007</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505074</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000008</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505075</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000008</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505075</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000008</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505075</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000009</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505076</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000010</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505077</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000011</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505078</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000012</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">505079</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000001</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506478</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000001</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506478</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000002</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506479</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000002</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506479</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000002</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506479</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">A</td> <td class="xl28" x:num="">39438</td> <td class="xl28" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">
</td> <td class="xl28">
</td> <td class="xl28">
</td> </tr> </tbody></table>
I want fill the blank cell


sheet 2
<table x:str="" style="border-collapse: collapse; width: 919pt;" border="0" cellpadding="0" cellspacing="0" width="1224"><col style="width: 77pt;" width="103"> <col style="width: 76pt;" width="101"> <col style="width: 142pt;" width="189"> <col style="width: 22pt;" width="29"> <col style="width: 62pt;" width="83"> <col style="width: 41pt;" width="55"> <col style="width: 103pt;" width="137"> <col style="width: 36pt;" width="48"> <col style="width: 96pt;" width="128"> <col style="width: 36pt;" span="4" width="48"> <col style="width: 71pt;" width="95"> <col style="width: 26pt;" width="34"> <col style="width: 23pt;" width="30"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt; width: 77pt;" height="17" width="103">
</td> <td class="xl28" style="width: 76pt;" width="101">
</td> <td class="xl28" style="width: 142pt;" width="189">
</td> <td class="xl28" style="width: 22pt;" width="29">
</td> <td class="xl28" style="width: 62pt;" width="83">
</td> <td class="xl28" style="width: 41pt;" width="55">
</td> <td class="xl28" style="width: 103pt;" width="137">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 96pt;" width="128">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 71pt;" width="95">
</td> <td class="xl28" style="width: 26pt;" width="34">
</td> <td class="xl28" style="width: 23pt;" width="30">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" id="_x0000_s2053" x:autofilter="all" x:autofilterrange="$A$2:$P$31" style="height: 12.75pt;" height="17">Code</td> <td class="xl27" id="_x0000_s2054" x:autofilter="all" style="border-left: medium none;">Customer Name</td> <td class="xl27" id="_x0000_s2055" x:autofilter="all" style="border-left: medium none;">Address</td> <td class="xl27" id="_x0000_s2056" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s2057" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s2058" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s2059" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s2060" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s2061" x:autofilter="all" style="border-left: medium none;">Kecamatan</td> <td class="xl27" id="_x0000_s2062" x:autofilter="all" style="border-left: medium none;">Rayon</td> <td class="xl27" id="_x0000_s2063" x:autofilter="all" style="border-left: medium none;">Class</td> <td class="xl27" id="_x0000_s2064" x:autofilter="all" style="border-left: medium none;">x</td> <td class="xl27" id="_x0000_s2065" x:autofilter="all" style="border-left: medium none;">Divisi</td> <td class="xl27" id="_x0000_s2066" x:autofilter="all" style="border-left: medium none;">KODESLS</td> <td class="xl27" id="_x0000_s2067" x:autofilter="all" style="border-left: medium none;">TO</td> <td class="xl27" id="_x0000_s2068" x:autofilter="all" style="border-left: medium none;">JO</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">EDI</td> <td class="xl28">PS. PANORAMA LOS G NO. 7</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">EDI</td> <td class="xl28">PS. PANORAMA LOS G NO. 7</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">EDI</td> <td class="xl28">PS. PANORAMA LOS G NO. 7</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">EDI</td> <td class="xl28">PS. PANORAMA LOS G NO. 7</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">EDI</td> <td class="xl28">PS. PANORAMA LOS G NO. 7</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000001</td> <td class="xl28">EDI</td> <td class="xl28">PS. PANORAMA LOS G NO. 7</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505068</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000002</td> <td class="xl28">SAMARA</td> <td class="xl28">PS. PANORAMA LOS B NO. 35 - 36</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505069</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000002</td> <td class="xl28">SAMARA</td> <td class="xl28">PS. PANORAMA LOS B NO. 35 - 36</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505069</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000003</td> <td class="xl28">TAWEKAL</td> <td class="xl28">PS. PANORAMA LOS B NO. 48</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505070</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000003</td> <td class="xl28">TAWEKAL</td> <td class="xl28">PS. PANORAMA LOS B NO. 48</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505070</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000005</td> <td class="xl28">WARNA WARNI</td> <td class="xl28">PS. PANORAMA LOS K NO. 47</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505072</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000006</td> <td class="xl28">PUTRA JAYA</td> <td class="xl28">JL. RY. LEMBANG NO. 275</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505073</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R02</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000007</td> <td class="xl28">H. KOKOM</td> <td class="xl28">PS. PANORAMA LOS G NO. 43 - 45</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505074</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000007</td> <td class="xl28">H. KOKOM</td> <td class="xl28">PS. PANORAMA LOS G NO. 43 - 45</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505074</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000007</td> <td class="xl28">H. KOKOM</td> <td class="xl28">PS. PANORAMA LOS G NO. 43 - 45</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505074</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000007</td> <td class="xl28">H. KOKOM</td> <td class="xl28">PS. PANORAMA LOS G NO. 43 - 45</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505074</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000008</td> <td class="xl28">H. AAY</td> <td class="xl28">PS. PANORAMA LOS H NO. 50 - 52</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505075</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000008</td> <td class="xl28">H. AAY</td> <td class="xl28">PS. PANORAMA LOS H NO. 50 - 52</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505075</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000008</td> <td class="xl28">H. AAY</td> <td class="xl28">PS. PANORAMA LOS H NO. 50 - 52</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505075</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">GR</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000009</td> <td class="xl28">SUMBER JAYA</td> <td class="xl28">JL. KAYU AMBON NO. 22</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505076</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R02</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000010</td> <td class="xl28">ANWAR</td> <td class="xl28">PS. PANORAMA LOS A NO. 15 - 17</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505077</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000011</td> <td class="xl28">BINTANG TIMUR</td> <td class="xl28">JL. KAYU AMBON NO. 10</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505078</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R02</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000011</td> <td class="xl28">BINTANG TIMUR</td> <td class="xl28">JL. KAYU AMBON NO. 10</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505078</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R02</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000012</td> <td class="xl28">AKIM</td> <td class="xl28">JL. KAYU AMBON NO. 12</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505079</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R02</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000012</td> <td class="xl28">AKIM</td> <td class="xl28">JL. KAYU AMBON NO. 12</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505079</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R02</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000012</td> <td class="xl28">AKIM</td> <td class="xl28">JL. KAYU AMBON NO. 12</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505079</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R02</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000013</td> <td class="xl28">TATANG</td> <td class="xl28">PS. PANORAMA LOS M NO. 48</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505059</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000013</td> <td class="xl28">TATANG</td> <td class="xl28">PS. PANORAMA LOS M NO. 48</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505059</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1800-0000013</td> <td class="xl28">TATANG</td> <td class="xl28">PS. PANORAMA LOS M NO. 48</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">505059</td> <td class="xl28">LEMBANG</td> <td class="xl28">BDG</td> <td class="xl28">LEMBANG</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1800-T001</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> </tbody></table>

sheet 3
<table x:str="" style="border-collapse: collapse; width: 919pt;" border="0" cellpadding="0" cellspacing="0" width="1224"><col style="width: 77pt;" width="103"> <col style="width: 76pt;" width="101"> <col style="width: 142pt;" width="189"> <col style="width: 22pt;" width="29"> <col style="width: 62pt;" width="83"> <col style="width: 41pt;" width="55"> <col style="width: 103pt;" width="137"> <col style="width: 36pt;" width="48"> <col style="width: 96pt;" width="128"> <col style="width: 36pt;" span="4" width="48"> <col style="width: 71pt;" width="95"> <col style="width: 26pt;" width="34"> <col style="width: 23pt;" width="30"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt; width: 77pt;" height="17" width="103">
</td> <td class="xl28" style="width: 76pt;" width="101">
</td> <td class="xl28" style="width: 142pt;" width="189">
</td> <td class="xl28" style="width: 22pt;" width="29">
</td> <td class="xl30" style="width: 62pt;" width="83">
</td> <td class="xl30" style="width: 41pt;" width="55">
</td> <td class="xl28" style="width: 103pt;" width="137">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 96pt;" width="128">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 36pt;" width="48">
</td> <td class="xl28" style="width: 71pt;" width="95">
</td> <td class="xl28" style="width: 26pt;" width="34">
</td> <td class="xl28" style="width: 23pt;" width="30">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Code</td> <td class="xl27" style="border-left: medium none;">Customer Name</td> <td class="xl27" style="border-left: medium none;">Address</td> <td class="xl27" style="border-left: medium none;">x</td> <td class="xl27" style="border-left: medium none;">x</td> <td class="xl27" style="border-left: medium none;">x</td> <td class="xl27" style="border-left: medium none;">x</td> <td class="xl27" style="border-left: medium none;">x</td> <td class="xl27" style="border-left: medium none;">Kecamatan</td> <td class="xl27" style="border-left: medium none;">Rayon</td> <td class="xl27" style="border-left: medium none;">Class</td> <td class="xl27" style="border-left: medium none;">x</td> <td class="xl27" style="border-left: medium none;">Divisi</td> <td class="xl27" style="border-left: medium none;">KODESLS</td> <td class="xl27" style="border-left: medium none;">TO</td> <td class="xl27" style="border-left: medium none;">JO</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000001</td> <td class="xl28">HEGARMANAH</td> <td class="xl28">JL. RY. PLERED NO. 67 B</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506478</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000002</td> <td class="xl28">BOGOR JAYA</td> <td class="xl28">PS. PLERED BLOK B NO. 102</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506479</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000003</td> <td class="xl28">H. MAMAN</td> <td class="xl28">PS. PLERED D 8</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506480</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SG</td> <td class="xl28">K+S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000003</td> <td class="xl28">H. MAMAN</td> <td class="xl28">PS. PLERED D 8</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506480</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SG</td> <td class="xl28">K+S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000003</td> <td class="xl28">H. MAMAN</td> <td class="xl28">PS. PLERED D 8</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506480</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SG</td> <td class="xl28">K+S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000004</td> <td class="xl28">SALUYU</td> <td class="xl28">PS. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506481</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000005</td> <td class="xl28">ASEP S.</td> <td class="xl28">PS. CILALAWI</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506482</td> <td class="xl28">SUKATANI</td> <td class="xl28">PWK</td> <td class="xl28">SUKATANI</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SG</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000006</td> <td class="xl28">ADE SKEW</td> <td class="xl28">JL. RY. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506483</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000007</td> <td class="xl28">BAROKAH</td> <td class="xl28">PS. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506444</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SR</td> <td class="xl28">S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000007</td> <td class="xl28">BAROKAH</td> <td class="xl28">PS. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506444</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SR</td> <td class="xl28">S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000007</td> <td class="xl28">BAROKAH</td> <td class="xl28">PS. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506444</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SR</td> <td class="xl28">S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000007</td> <td class="xl28">BAROKAH</td> <td class="xl28">PS. PLERED</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506444</td> <td class="xl28">PLERED</td> <td class="xl28">PWK</td> <td class="xl28">PLERED 2</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">SR</td> <td class="xl28">S</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000008</td> <td class="xl28">ZAENAL</td> <td class="xl28">JL.RY. CILALAWI</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506445</td> <td class="xl28">SUKATANI</td> <td class="xl28">PWK</td> <td class="xl28">SUKATANI</td> <td class="xl28">R03</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">RT</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">MUSTIKA</td> <td class="xl28">JL. SURADIREJA NO. 81</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">MUSTIKA</td> <td class="xl28">JL. SURADIREJA NO. 81</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">MUSTIKA</td> <td class="xl28">JL. SURADIREJA NO. 81</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">MUSTIKA</td> <td class="xl28">JL. SURADIREJA NO. 81</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">MUSTIKA</td> <td class="xl28">JL. SURADIREJA NO. 81</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">1801-0000057</td> <td class="xl28">MUSTIKA</td> <td class="xl28">JL. SURADIREJA NO. 81</td> <td class="xl28">A</td> <td class="xl29" x:num="39438">12/22/2007</td> <td class="xl30" x:num="">506411</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">PWK</td> <td class="xl28">PURWAKARTA</td> <td class="xl28">R01</td> <td class="xl28">TM</td> <td class="xl28">TO</td> <td class="xl28">TO</td> <td class="xl28">1801-T002</td> <td class="xl28">GR</td> <td class="xl28">K+S+B</td> </tr> </tbody></table>

can anyone help me... :confused:
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
ok sory, i want to fill cell F3 on sheet1, with macro function likes vlookup formula.<table x:str="" style="border-collapse: collapse; width: 720pt;" border="0" cellpadding="0" cellspacing="0" width="957"><tbody><tr style="height: 12.75pt;" height="17"><td style="height: 12.75pt; width: 81pt;" height="17" width="108">
</td><td style="width: 76pt;" width="101">
</td><td style="width: 80pt;" width="106">
</td><td style="width: 21pt;" width="28">
</td><td style="width: 40pt;" width="53">
</td><td style="width: 40pt;" width="53">
</td><td style="width: 32pt;" width="43">
</td><td style="width: 32pt;" width="43">
</td><td style="width: 79pt;" width="105">
</td><td style="width: 29pt;" width="39">
</td><td style="width: 38pt;" width="50">
</td><td style="width: 17pt;" width="22">
</td><td style="width: 32pt;" width="42">
</td><td style="width: 63pt;" width="84">
</td><td style="width: 20pt;" width="27">
</td><td style="width: 40pt;" width="53">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl27" id="_x0000_s1029" x:autofilter="all" x:autofilterrange="$A$2:$P$19" style="height: 12.75pt;" height="17">
</td><td class="xl27" id="_x0000_s1030" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1031" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1032" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1033" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1034" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1035" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1036" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1037" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1038" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1039" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1040" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1041" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1042" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1043" x:autofilter="all" style="border-left: medium none;">
</td><td class="xl27" id="_x0000_s1044" x:autofilter="all" style="border-left: medium none;">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl28" style="height: 12.75pt;" height="17">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28" x:num="">
</td><td class="xl28" x:num="">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td><td class="xl28">
</td> </tr> </tbody></table>
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Macro to change VLookup Range
Replies
1
Views
604
footoo
F
R
  • Question
Returning a value using multiple criteria
Replies
4
Views
630
Fluff
Fluff
B
  • Question
Vlookup in Array rather than looping
Replies
4
Views
784
Norie
Norie
G
  • Question
SUMIF name and total hours are within specific date range
2 3
Replies
21
Views
2K
Glasgow Girl
G
R
  • Question
Comparing columns of data between worksheets and returning value when matched.
Replies
7
Views
914
Ronanm
R

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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