a macro for comparing columns; from A to H

[amin maaleki]

with hello and regards two all members and Mr. Excel
i have this table
<table style="border-collapse: collapse; width: 489pt;" border="0" cellpadding="0" cellspacing="0" width="653"><col style="width: 65pt;" width="87"> <col style="width: 51pt;" width="68"> <col style="width: 65pt;" width="87"> <col style="width: 53pt;" width="71"> <col style="width: 71pt;" width="95"> <col style="width: 54pt;" span="2" width="72"> <col style="width: 76pt;" width="101"> <tbody><tr style="height: 14.25pt;" height="19"> <td class="xl63" style="height: 14.25pt; width: 65pt;" height="19" width="87">A</td> <td class="xl63" style="width: 51pt;" width="68">B</td> <td class="xl63" style="width: 65pt;" width="87">C</td> <td class="xl63" style="width: 53pt;" width="71">D</td> <td class="xl63" style="width: 71pt;" width="95">E</td> <td class="xl63" style="width: 54pt;" width="72">F</td> <td class="xl63" style="width: 54pt;" width="72">G</td> <td class="xl63" style="width: 76pt;" width="101">H</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="height: 14.25pt;" height="19">COUNTRY1</td> <td class="xl64" style="border-left: medium none;">EXPORT$</td> <td class="xl64" style="border-left: medium none;">COUNTRY2</td> <td class="xl64" style="border-left: medium none;">IMPORT$</td> <td class="xl64" style="border-left: medium none;">SAME CODE</td> <td class="xl64" style="border-left: medium none;">EXPORT$</td> <td class="xl64" style="border-left: medium none;">IMPORT$</td> <td class="xl64" style="border-left: medium none;">30% MINOR</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">117</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">294</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10210</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">74</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10210</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">138</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10290</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10290</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">29</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10511</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">27</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10511</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10519</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">127</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10519</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">70</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10639</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">127</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10639</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">47</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">10690</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">19</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10690</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">47</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">…</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">961700</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">19</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">961700</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">18</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">961800</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">558</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">961800</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970110</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970110</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">27</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">116</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970190</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970500</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970500</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl64" style="border-top: medium none; height: 14.25pt;" height="19">970600</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">970600</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">91,969</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>
Column A: Country1 Export Code
Column B: Export value for Country 1
Column C: Country2 Import Code
Column D: Import value for Country 2

excel 2003 file
http://www.4shared.com/account/file/101679321/3bef232d/file.html?sId=cQbrAl6Snyxwpbv0
excel 2007 file
http://www.4shared.com/account/file/101679319/1e19f8dc/file.html?sId=cQbrAl6Snyxwpbv0

NOW
i want to fill in Column E to H with a macro
Column E: same code in Column A and Column C
Column F: export value for same code (from Column B)
Column G: import value for same code (from Column D)
Column H: 30 percent of Minor Value
for example if F3 is 9000 and G3 is 1000 then H3 will be 2700 that is 30 percent of F3

thanks a lot for your attention
sincerely
amin

 

[Legacy 68668]

If you don't have blank row(s)/column(s) within a data range, it should work.