Hi all
Could you please help me show the missing numbers in Station column using Excel VBA? I tried to use conditional formatting but that's not exactly what I want to do. On line 1003, station 5000 is also missing. I want to put all missing sequential station numbers on another sheet. Thanks.
Line Station Difference
<table border="0" cellpadding="0" cellspacing="0" width="192"><tbody></tbody></table><table border="0" cellpadding="0" cellspacing="0" width="192"> <colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;width:48pt" height="20" width="64">1000</td> <td class="xl65" style="border-left:none;width:48pt" width="64">5069</td> <td class="xl65" style="border-left:none;width:48pt" width="64">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5070</td> <td class="xl65" style="border-top:none;border-left:none;font-size:11.0pt; color:white;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:red;mso-pattern:black none">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5072</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5073</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5074</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5075</td> <td class="xl65" style="border-top:none;border-left:none;font-size:11.0pt; color:white;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:red;mso-pattern:black none">4</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5079</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5080</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5081</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5082</td> <td class="xl65" style="border-top:none;border-left:none">-81</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1003</td> <td class="xl65" style="border-top:none;border-left:none">5001</td> <td class="xl65" style="border-top:none;border-left:none">1
</td> </tr> </tbody></table>
Could you please help me show the missing numbers in Station column using Excel VBA? I tried to use conditional formatting but that's not exactly what I want to do. On line 1003, station 5000 is also missing. I want to put all missing sequential station numbers on another sheet. Thanks.
Line Station Difference
<table border="0" cellpadding="0" cellspacing="0" width="192"><tbody></tbody></table><table border="0" cellpadding="0" cellspacing="0" width="192"> <colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;width:48pt" height="20" width="64">1000</td> <td class="xl65" style="border-left:none;width:48pt" width="64">5069</td> <td class="xl65" style="border-left:none;width:48pt" width="64">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5070</td> <td class="xl65" style="border-top:none;border-left:none;font-size:11.0pt; color:white;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:red;mso-pattern:black none">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5072</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5073</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5074</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5075</td> <td class="xl65" style="border-top:none;border-left:none;font-size:11.0pt; color:white;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:red;mso-pattern:black none">4</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5079</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5080</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5081</td> <td class="xl65" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1000</td> <td class="xl65" style="border-top:none;border-left:none">5082</td> <td class="xl65" style="border-top:none;border-left:none">-81</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">1003</td> <td class="xl65" style="border-top:none;border-left:none">5001</td> <td class="xl65" style="border-top:none;border-left:none">1
</td> </tr> </tbody></table>