Extract and arrange the numbers small to larger values

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,782
Hello,</SPAN></SPAN>

I need to extract the numbers of column E:N and need to arrange them in order small to larger values in the columns P:Y
</SPAN></SPAN>

Example

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #0000FF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n5</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n6</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n7</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n8</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n5</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n6</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n7</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n8</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">n10</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FF0000;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr></tbody></table><p style="width:3,6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

Thank you all
</SPAN></SPAN>

Excel 2000
</SPAN></SPAN>
Regards,
</SPAN></SPAN>
Moti
</SPAN></SPAN>
 
Last edited:

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,465
Office Version
365, 2010
Platform
Windows
How about this:

Code:
Sub RemZero()

    Dim rng1 As Range, rng2 As Range, r As Long
    
    Application.ScreenUpdating = False
    Set rng1 = Range("A4:J" & Cells(Rows.Count, 1).End(xlUp).Row)
    rng1.Copy Range("L4")
    Set rng2 = Range("L4:U" & Cells(Rows.Count, 1).End(xlUp).Row)
    For r = rng2.Cells.Count To 1 Step -1
        If rng2.Cells(r) = 0 Then rng2.Cells(r).Delete Shift:=xlToLeft
    Next
    Application.ScreenUpdating = True
        
End Sub
 
Last edited:

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
9,780
Office Version
2007
Platform
Windows
Just another way to do it.

Code:
Sub arrange_numbers1()
  Dim c As Range
  For Each c In Range("E4:N" & Range("E" & Rows.Count).End(xlUp).Row)
    If c <> 0 Then Cells(c.Row, Cells(c.Row, Columns.Count).End(xlToLeft).Column + 1) = c
  Next
  Range("O4:O" & Range("E" & Rows.Count).End(xlUp).Row).Insert Shift:=xlToRight
End Sub
 

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,782
How about this:

Code:
Sub RemZero()

    Dim rng1 As Range, rng2 As Range, r As Long
    
    Application.ScreenUpdating = False
    Set rng1 = Range("A4:J" & Cells(Rows.Count, 1).End(xlUp).Row)
    rng1.Copy Range("L4")
    Set rng2 = Range("L4:U" & Cells(Rows.Count, 1).End(xlUp).Row)
    For r = rng2.Cells.Count To 1 Step -1
        If rng2.Cells(r) = 0 Then rng2.Cells(r).Delete Shift:=xlToLeft
    Next
    Application.ScreenUpdating = True
        
End Sub
igold, thank you for the code you provide it works I need to shift the data in the blank sheet and run the code, if I run in the same sheet it disturb all the right columns data I got all the time columns E:N data update every day so is it possible the code work in the same sheet and update columns P:Y </SPAN></SPAN>

Kind Regards,
</SPAN></SPAN>
Moti
</SPAN></SPAN>
 

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,782
Just another way to do it.

Code:
Sub arrange_numbers1()
  Dim c As Range
  For Each c In Range("E4:N" & Range("E" & Rows.Count).End(xlUp).Row)
    If c <> 0 Then Cells(c.Row, Cells(c.Row, Columns.Count).End(xlToLeft).Column + 1) = c
  Next
  Range("O4:O" & Range("E" & Rows.Count).End(xlUp).Row).Insert Shift:=xlToRight
End Sub
DanteAmor, thank you for the code it is printing the results end of the used columns I need the result must be in P:Y columns without disturbing other columns data</SPAN></SPAN>

Kind Regards,
</SPAN></SPAN>
Moti
</SPAN></SPAN>
 

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,465
Office Version
365, 2010
Platform
Windows
Change the highlighted lines to where you want the results returned...

Code:
Sub RemZero()


    Dim rng1 As Range, rng2 As Range, r As Long
    
    Application.ScreenUpdating = False
    Set rng1 = Range("A4:J" & Cells(Rows.Count, 1).End(xlUp).Row)
    rng1.Copy [COLOR=#ff0000]Range("L4")[/COLOR]
    Set rng2 = [COLOR=#ff0000]Range("L4:U"[/COLOR] & Cells(Rows.Count, 1).End(xlUp).Row)
    For r = rng2.Cells.Count To 1 Step -1
        If rng2.Cells(r) = 0 Then rng2.Cells(r).Delete Shift:=xlToLeft
    Next
    Application.ScreenUpdating = True
        
End Sub
 
Last edited:

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,576
Office Version
2010
Platform
Windows
Am I remembering correctly from past postings of yours... except for the zero values, aren't your numbers in each row of Columns E:N always in sorted numerical order from left to right? If so, this should work for you...
Code:
Sub DumpZeros()
  Range("E3").CurrentRegion.Copy Range("P3")
  With Range("P3").CurrentRegion
    .Replace 0, "", xlWhole, , , , False, False
    .SpecialCells(xlBlanks).Delete xlShiftToLeft
  End With
End Sub
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
9,780
Office Version
2007
Platform
Windows
DanteAmor, thank you for the code it is printing the results end of the used columns I need the result must be in P:Y columns without disturbing other columns data

Kind Regards,

Moti

Try this, This should write from P to Y without altering other columns.

Code:
Sub arrange_numbers1()
  Dim c As Range, j As Long
  For Each c In Range("E4:N" & Range("E" & Rows.Count).End(xlUp).Row)
    If c.Column = 5 Then j = Columns("P").Column
    If c <> 0 Then
      Cells(c.Row, j) = c
      j = j + 1
    End If
  Next
End Sub
 

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
1,782
Rick, code also is giving problem having data in the right columns, to be specific here is how my data looks I want result in columns P:Y without disturbing any data of the columns AA:AJ...</SPAN></SPAN>

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th><th>Z</th><th>AA</th><th>AB</th><th>AC</th><th>AD</th><th>AE</th><th>AF</th><th>AG</th><th>AH</th><th>AI</th><th>AJ</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #0000FF;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;;"></td><td style="text-align: right;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #0000FF;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td><td style="text-align: right;color: #333333;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-align: center;color: #333333;;">n1</td><td style="font-weight: bold;text-align: center;color: #333333;;">n2</td><td style="font-weight: bold;text-align: center;color: #333333;;">n3</td><td style="font-weight: bold;text-align: center;color: #333333;;">n4</td><td style="font-weight: bold;text-align: center;color: #333333;;">n5</td><td style="font-weight: bold;text-align: center;color: #333333;;">n6</td><td style="font-weight: bold;text-align: center;color: #333333;;">n7</td><td style="font-weight: bold;text-align: center;color: #333333;;">n8</td><td style="font-weight: bold;text-align: center;color: #333333;;">n9</td><td style="font-weight: bold;text-align: center;color: #333333;;">n10</td><td style="text-align: right;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">n1</td><td style="font-weight: bold;text-align: center;color: #333333;;">n2</td><td style="font-weight: bold;text-align: center;color: #333333;;">n3</td><td style="font-weight: bold;text-align: center;color: #333333;;">n4</td><td style="font-weight: bold;text-align: center;color: #333333;;">n5</td><td style="font-weight: bold;text-align: center;color: #333333;;">n6</td><td style="font-weight: bold;text-align: center;color: #333333;;">n7</td><td style="font-weight: bold;text-align: center;color: #333333;;">n8</td><td style="font-weight: bold;text-align: center;color: #333333;;">n9</td><td style="font-weight: bold;text-align: center;color: #333333;;">n10</td><td style="text-align: right;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">n1</td><td style="font-weight: bold;text-align: center;color: #333333;;">n2</td><td style="font-weight: bold;text-align: center;color: #333333;;">n3</td><td style="font-weight: bold;text-align: center;color: #333333;;">n4</td><td style="font-weight: bold;text-align: center;color: #333333;;">n5</td><td style="font-weight: bold;text-align: center;color: #333333;;">n6</td><td style="font-weight: bold;text-align: center;color: #333333;;">n7</td><td style="font-weight: bold;text-align: center;color: #333333;;">n8</td><td style="font-weight: bold;text-align: center;color: #333333;;">n9</td><td style="font-weight: bold;text-align: center;color: #333333;;">n10</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">15</td><td style="font-weight: bold;text-align: center;color: #333333;;">20</td><td style="font-weight: bold;text-align: center;color: #333333;;">23</td><td style="font-weight: bold;text-align: center;color: #333333;;">27</td><td style="font-weight: bold;text-align: center;color: #333333;;">40</td><td style="font-weight: bold;text-align: center;color: #333333;;">3</td><td style="font-weight: bold;text-align: center;color: #333333;;">22</td><td style="font-weight: bold;text-align: center;color: #333333;;">25</td><td style="font-weight: bold;text-align: center;color: #333333;;">30</td><td style="font-weight: bold;text-align: center;color: #333333;;">49</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;">22</td><td style="font-weight: bold;text-align: center;color: #333333;;">33</td><td style="font-weight: bold;text-align: center;color: #333333;;">44</td><td style="font-weight: bold;text-align: center;color: #333333;;">50</td><td style="font-weight: bold;text-align: center;color: #333333;;">1</td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;">27</td><td style="font-weight: bold;text-align: center;color: #333333;;">42</td><td style="font-weight: bold;text-align: center;color: #333333;;">47</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;">29</td><td style="font-weight: bold;text-align: center;color: #333333;;">36</td><td style="font-weight: bold;text-align: center;color: #333333;;">38</td><td style="font-weight: bold;text-align: center;color: #333333;;">22</td><td style="font-weight: bold;text-align: center;color: #333333;;">37</td><td style="font-weight: bold;text-align: center;color: #333333;;">43</td><td style="font-weight: bold;text-align: center;color: #333333;;">44</td><td style="font-weight: bold;text-align: center;color: #333333;;">45</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">2</td><td style="font-weight: bold;text-align: center;color: #333333;;">14</td><td style="font-weight: bold;text-align: center;color: #333333;;">35</td><td style="font-weight: bold;text-align: center;color: #333333;;">41</td><td style="font-weight: bold;text-align: center;color: #333333;;">42</td><td style="font-weight: bold;text-align: center;color: #333333;;">8</td><td style="font-weight: bold;text-align: center;color: #333333;;">21</td><td style="font-weight: bold;text-align: center;color: #333333;;">25</td><td style="font-weight: bold;text-align: center;color: #333333;;">38</td><td style="font-weight: bold;text-align: center;color: #333333;;">50</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">12</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;">29</td><td style="font-weight: bold;text-align: center;color: #333333;;">31</td><td style="font-weight: bold;text-align: center;color: #333333;;">33</td><td style="font-weight: bold;text-align: center;color: #333333;;">40</td><td style="font-weight: bold;text-align: center;color: #333333;;">2</td><td style="font-weight: bold;text-align: center;color: #333333;;">33</td><td style="font-weight: bold;text-align: center;color: #333333;;">42</td><td style="font-weight: bold;text-align: center;color: #333333;;">47</td><td style="font-weight: bold;text-align: center;color: #333333;;">48</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">13</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">27</td><td style="font-weight: bold;text-align: center;color: #333333;;">37</td><td style="font-weight: bold;text-align: center;color: #333333;;">42</td><td style="font-weight: bold;text-align: center;color: #333333;;">24</td><td style="font-weight: bold;text-align: center;color: #333333;;">37</td><td style="font-weight: bold;text-align: center;color: #333333;;">41</td><td style="font-weight: bold;text-align: center;color: #333333;;">43</td><td style="font-weight: bold;text-align: center;color: #333333;;">46</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">3</td><td style="font-weight: bold;text-align: center;color: #333333;;">4</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">3</td><td style="font-weight: bold;text-align: center;color: #333333;;">4</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">10</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">20</td><td style="font-weight: bold;text-align: center;color: #333333;;">22</td><td style="font-weight: bold;text-align: center;color: #333333;;">23</td><td style="font-weight: bold;text-align: center;color: #333333;;">24</td><td style="font-weight: bold;text-align: center;color: #333333;;">37</td><td style="font-weight: bold;text-align: center;color: #333333;;">2</td><td style="font-weight: bold;text-align: center;color: #333333;;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">18</td><td style="font-weight: bold;text-align: center;color: #333333;;">40</td><td style="font-weight: bold;text-align: center;color: #333333;;">46</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;text-align: center;color: #333333;;">1</td><td style="font-weight: bold;text-align: center;color: #333333;;">2</td><td style="font-weight: bold;text-align: center;color: #333333;;">3</td><td style="font-weight: bold;text-align: center;color: #333333;;">4</td><td style="font-weight: bold;text-align: center;color: #333333;;">5</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">0</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">1</td><td style="font-weight: bold;text-align: center;color: #333333;;">2</td><td style="font-weight: bold;text-align: center;color: #333333;;">3</td><td style="font-weight: bold;text-align: center;color: #333333;;">4</td><td style="font-weight: bold;text-align: center;color: #333333;;">5</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;"></td><td style="font-weight: bold;text-align: center;color: #333333;;">4</td><td style="font-weight: bold;text-align: center;color: #333333;;">17</td><td style="font-weight: bold;text-align: center;color: #333333;;">35</td><td style="font-weight: bold;text-align: center;color: #333333;;">42</td><td style="font-weight: bold;text-align: center;color: #333333;;">45</td><td style="font-weight: bold;text-align: center;color: #333333;;">6</td><td style="font-weight: bold;text-align: center;color: #333333;;">9</td><td style="font-weight: bold;text-align: center;color: #333333;;">35</td><td style="font-weight: bold;text-align: center;color: #333333;;">41</td><td style="font-weight: bold;text-align: center;color: #333333;;">44</td></tr></tbody></table><p style="width:3,6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

Kind Regards, </SPAN></SPAN>
Moti </SPAN></SPAN>
 
Last edited:

mohadin

Active Member
Joined
Mar 22, 2015
Messages
361
Office Version
2013
Platform
Windows
HI
What about
Code:
Sub test()
    Dim b As Variant
    Dim lr, i
       For i = 5 To Cells(Rows.Count, 5).End(xlUp).Row
        ReDim b(1 To 10)
        t = 1
        For j = 5 To 15
            If Cells(i, j) <> 0 Then
                b(t) = Cells(i, j): t = t + 1
            End If
        Next
        Cells(i, 16).Resize(, UBound(b)) = b
    Next
End Sub
 
Last edited:

Forum statistics

Threads
1,086,220
Messages
5,388,542
Members
402,119
Latest member
matts17

Some videos you may like

This Week's Hot Topics

Top