a macro for comparing columns; from A to H

A

amin maaleki

New Member
Joined
Apr 13, 2009
Messages
21
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
 
Sort by date Sort by votes
ok, after running macro 1 to 3 rows for E to H columns will be such as this:
<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="xl68" style="border-top: medium none; height: 14.25pt;" height="19">10190</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">117</td> <td class="xl63">10185</td> <td class="xl64" style="border-top: medium none;">294</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">10190</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">117</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">138</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">35.1</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl65" style="border-top: medium none; height: 14.25pt;" height="19">10210</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">74</td> <td class="xl68" style="border-left: medium none;">10190</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">138</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">10210</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">74</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">3.3</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="xl65" style="border-top: medium none; border-left: medium none;">10210</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">10639</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">50</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">47</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">5.4</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl66" style="border-top: medium none; height: 14.25pt;" height="19">10639</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">27</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10212</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="xl67" style="height: 14.25pt;" height="19">10639</td> <td class="xl66" style="border-top: medium none;">23</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">10213</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="height: 14.25pt;" height="19">10890</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">127</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">10639</td> <td class="xl66" 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">11141</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">19</td> <td class="xl63">10721</td> <td class="xl63">52</td> <td class="xl64" style="border-top: 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>

thanks a lot, please help
 
Upvote 0

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
I think this can be solved with the formula...
Hope someone good at formula will come in.

vba
Code: 
Sub test()
Dim a, i As Long
With Range("a1").CurrentRegion.Resize(, 8)
    .Value = a
    With CreateObject("Scripting.Dictionary")
        For i = 2 To UBound(a, 1)
            .item(a(i, 3)) = a(i, 4)
        Next
        For i = 2 To UBound(a, 1)
            a(i, 5) = a(i, 1) : a(i, 6) = a(i, 2)
            If .exists(a(i, 1)) Then a(i, 7) = .item(a(i, 1))
            a(i, 8) = Application.Max(a(i, 6), a(i, 7)) * 0.3
        Next
    End With
    .Value = a
End With
End Sub
 
Upvote 0
You need to show us exactly how your data is laid.

The code is assuming the heading in the 1st row and the data starts from col.A
 
Upvote 0
I can not D/L any file and I need to go now.

I will post the reply on day after (busy tomorrow), if you show me the sheet.
 
Upvote 0
sheet here:
<table style="border-collapse: collapse; width: 432pt;" border="0" cellpadding="0" cellspacing="0" width="576"><col style="width: 54pt;" span="8" width="72"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; width: 54pt;" height="15" width="72">country1</td> <td class="xl63" style="width: 54pt;" width="72">export</td> <td class="xl63" style="width: 54pt;" width="72">country2</td> <td class="xl63" style="width: 54pt;" width="72">import</td> <td class="xl63" style="width: 54pt;" width="72">same code</td> <td class="xl63" style="width: 54pt;" width="72">export$</td> <td class="xl63" style="width: 54pt;" width="72">import$</td> <td class="xl64" style="width: 54pt;" width="72">30%</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">101</td> <td class="xl65">20</td> <td class="xl65">101</td> <td class="xl65">12,295</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">102</td> <td class="xl65">67</td> <td class="xl65">102</td> <td class="xl65">24,978</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">104</td> <td class="xl65">32,183</td> <td class="xl65">103</td> <td class="xl65">535</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">105</td> <td class="xl65">1,658</td> <td class="xl65">104</td> <td class="xl65">76,617</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">106</td> <td class="xl65">1,176</td> <td class="xl65">105</td> <td class="xl65">3,199</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">201</td> <td class="xl65">32</td> <td class="xl65">106</td> <td class="xl65">16,362</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">201</td> <td class="xl65">35</td> <td class="xl65">201</td> <td class="xl65">51,185</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">203</td> <td class="xl65">78</td> <td class="xl65">202</td> <td class="xl65">75,950</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">204</td> <td class="xl65">2,291</td> <td class="xl65">203</td> <td class="xl65">15,841</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">206</td> <td class="xl65">2,112</td> <td class="xl65">204</td> <td class="xl65">137,484</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">207</td> <td class="xl65">12,806</td> <td class="xl65">205</td> <td class="xl65">125</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">210</td> <td class="xl65">6</td> <td class="xl65">206</td> <td class="xl65">4,549</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">301</td> <td class="xl65">535</td> <td class="xl65">207</td> <td class="xl65">230,964</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">302</td> <td class="xl65">9,963</td> <td class="xl65">208</td> <td class="xl65">2,203</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">303</td> <td class="xl65">18,146</td> <td class="xl65">209</td> <td class="xl65">601</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">304</td> <td class="xl65">74</td> <td class="xl65">210</td> <td class="xl65">5,838</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">305</td> <td class="xl65">6</td> <td class="xl65">301</td> <td class="xl65">2,144</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">306</td> <td class="xl65">12,262</td> <td class="xl65">302</td> <td class="xl65">23,864</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">307</td> <td class="xl65">381</td> <td class="xl65">303</td> <td class="xl65">29,190</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt;" height="15">401</td> <td class="xl65">10,289</td> <td class="xl65">303</td> <td class="xl65">356,212</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> <td class="xl63">
</td> </tr> </tbody></table>
 
Upvote 0
I need the row/column index of the heading.

such like

header starts from col.A row1
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
VBA for Web Scraping help
Replies
0
Views
600
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
439
AndyEd
A
M
  • Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M
A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A

Forum statistics

Threads
1,215,329
Messages
6,124,301
Members
449,149
Latest member
mwdbActuary

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