Data verification thru Macros

[pavanranjan]

Dear Sir

I have my query as below :-

<table style="width: 431px; height: 88px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 51pt;" width="68" span="2"> <col style="width: 21pt;" width="28"> <col style="width: 64pt;" width="85"> <col style="width: 33pt;" width="44"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 51pt;" width="68" height="17">Inv No</td> <td class="xl25" style="border-left: medium none; width: 51pt;" width="68">SKU</td> <td class="xl25" style="border-left: medium none; width: 21pt;" width="28">Qty</td> <td class="xl25" style="border-left: medium none; width: 64pt;" width="85">Rate
</td> <td class="xl25" style="border-left: medium none; width: 33pt;" width="44">Check</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; border-top: medium none;" height="17">IN2030125</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">IZ131</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">565</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">20.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="center">TRUE</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; border-top: medium none;" height="17">IN2030126</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">IC258</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">446</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">6.12</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="center">TRUE</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; border-top: medium none;" height="17">IN2030127</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">IW125</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">44</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">10.12</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="center">TRUE</td> </tr> </tbody></table>
I need to cross check same kind of data thru database with 4 unique columns ,what is the best way to do the check in auto mode thru macros ?

 

[pavanranjan]

Macros

Dear Sir

I have one database of the following details , i need the below resul using macros ,please help me for the same

Database
<table style="width: 499px; height: 352px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 51pt;" width="68"> <col style="width: 48pt;" width="64" span="3"> <col style="width: 74pt;" width="99"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 51pt;" width="68" height="17">Inv No</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Code</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Qty</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">per unit</td> <td style="width: 74pt;" width="99">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030125</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">IZ131</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">20</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">20</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030126</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">IS256</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">39</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">33.69</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030127</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">IS269</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">58</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">47.38</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030128</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">IS290</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">77</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">61.07</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030129</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">IS299</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">96</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">74.76</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030130</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">uq698</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">115</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">88.45</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030131</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">dh987</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">134</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">102.14</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030132</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">df369</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">153</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">115.83</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Result required
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Inv No</td> <td class="xl24" style="border-left: medium none;">Code</td> <td class="xl24" style="border-left: medium none;">Qty</td> <td class="xl24" style="border-left: medium none;">per unit</td> <td class="xl24" style="border-left: medium none;">Check</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030125</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">IZ131</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">20</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">20</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> Data is true</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030131</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">dh987</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">39</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">33.69</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> Data is true</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">IN2030131</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">dh987</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">58</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" align="right">36.5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> Data is incorect</td> </tr> </tbody></table>