VB code to re-arrange rows to complete the series of number?

[sezuh]

Hi,thank you for the wonderful help you provided me on my other treads.
I'm hoping i'll get some advice on this one.
I have a table "list"made of 57 rows and 5 column and assigned with string "array" of 4 numbers in each row.without touching column "A" i need a vb code to re-arrange the rows on "B:E columns" to get 1 to 20 numbers series in each row.i hope it's clear to understand.
here is the list and some result;
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>LIST</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 03 05</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 10 14 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 09 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 11 12 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 04 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 10 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 14 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 11 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 11 14 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 06 08</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 11 13 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 11 17 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 07 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 11 14 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 05 07</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 13 14 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 09 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 12 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 08 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 09 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 15 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 10 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 13 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 09 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 09 14 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 12 14</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 15 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 10 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 09 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 16 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 18 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 11 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 10 15 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 10 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 15 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 11 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 09 11</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 13 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 11 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 11 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 12 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 06 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 12 14 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 13 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 08 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 13 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 14 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 04 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 09 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 13 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 15 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 06 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 04 06</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 11 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 14 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 10 13 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 07 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 07 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 12 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 10 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 10 14 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 08 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 08 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 13 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 11 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 10 16 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 09 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 10 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 14 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 11 13 14</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 10 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 14 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 07 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 11 16 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 11 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 08 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 07 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 12 13 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 05 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 10 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 10 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 12 15 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 05 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 07 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 14 15 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 06 07</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 08 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 12 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 10 12</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 08 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 09 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 13 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 13 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 09 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 10 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 08 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 17 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 10 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 11 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 08 11 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 10 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 11 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 12 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 08 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 10 11 13</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 12 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 08 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 10 14 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 06 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 10 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 10 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 06 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 07 08</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 12 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 11 14 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 07 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 09 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 13 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 10 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 11 15 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 08 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 11 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 11 17 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 12 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 10 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 12 14 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 12 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 10 13 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 12 17 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">35</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 10 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 11 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 13 16 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">36</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 15 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 07 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 11 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 11 12 14</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">37</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 09 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 09 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 11 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 11 15 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">38</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 10 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 10 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 12 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 11 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">39</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 11 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 12 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 12 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 12 15 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">40</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 14 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 13 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 13 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 13 15 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 12 18 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">41</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 08 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 15 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 14 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 13 15 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">42</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 09 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 10 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 10 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 11 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 14 17 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">43</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 10 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 11 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 12 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 12 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 12 13 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">44</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 11 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 12 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 12 16 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">45</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 12 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 15 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 13 16 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">46</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 09 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 06 08</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 08 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 14 16 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">47</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 09 10 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 09 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 09 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 11 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 15 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">48</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 09 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 09 12 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 10 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 13 14 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">49</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 09 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 09 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 11 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 13 17 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">50</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 10 12 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 10 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 12 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 14 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 15 17 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">51</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 10 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 10 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 16 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">52</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 11 12 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 10 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 11 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">13 14 15 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">53</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 11 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 11 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 09 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">13 14 18 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">54</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 12 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 11 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 12 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">13 16 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">55</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 13 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 12 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 13 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">14 15 16 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">56</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 14 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 12 15 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 10 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">14 17 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">57</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 15 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 14 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 10 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">15 16 17 19</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">58</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 17 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 11 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 08 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 10 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">16 17 18 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">59</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">EXPECTED RESULT</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">60</TD><TD style="FONT-WEIGHT: bold">01 02 03 05</TD><TD style="FONT-WEIGHT: bold">04 06 16 18</TD><TD style="FONT-WEIGHT: bold">07 10 12 13</TD><TD style="FONT-WEIGHT: bold">08 14 15 20</TD><TD style="FONT-WEIGHT: bold">09 11 17 19</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">61</TD><TD style="FONT-WEIGHT: bold">01 02 04 20</TD><TD style="FONT-WEIGHT: bold">03 05 10 16</TD><TD style="FONT-WEIGHT: bold">06 09 11 12</TD><TD style="FONT-WEIGHT: bold">07 08 18 19</TD><TD style="FONT-WEIGHT: bold">13 14 15 17</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">62</TD><TD style="FONT-WEIGHT: bold">01 02 06 08</TD><TD style="FONT-WEIGHT: bold">03 04 09 17</TD><TD style="FONT-WEIGHT: bold">05 07 11 16</TD><TD style="FONT-WEIGHT: bold">10 12 15 19</TD><TD style="FONT-WEIGHT: bold">13 14 18 20</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">63</TD><TD style="FONT-WEIGHT: bold">01 02 07 15</TD><TD style="FONT-WEIGHT: bold">03 04 08 10</TD><TD style="FONT-WEIGHT: bold">05 13 19 20</TD><TD style="FONT-WEIGHT: bold">06 09 14 17</TD><TD style="FONT-WEIGHT: bold">11 12 16 18</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">64</TD><TD style="FONT-WEIGHT: bold">01 02 09 17</TD><TD style="FONT-WEIGHT: bold">03 04 11 19</TD><TD style="FONT-WEIGHT: bold">05 07 13 15</TD><TD style="FONT-WEIGHT: bold">06 08 14 16</TD><TD style="FONT-WEIGHT: bold">10 12 18 20</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">65</TD><TD style="FONT-WEIGHT: bold">01 02 10 11</TD><TD style="FONT-WEIGHT: bold">03 04 05 07</TD><TD style="FONT-WEIGHT: bold">06 08 13 19</TD><TD style="FONT-WEIGHT: bold">09 12 14 15</TD><TD style="FONT-WEIGHT: bold">16 17 18 20</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">66</TD><TD style="FONT-WEIGHT: bold">....Up to 57 ROW</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>

Kind regards
Sezuh

 

[sezuh]

Mick,how its possible i get some number in column "A" repeated in columns "B:E" when i run the first code, yet when i checked your example in post #19 there were none,what am I doing wrong?
i would much appreciate if you could shed light to this problem....
thanks and Kind regards,
Sezuh

 

[MickG]

Here is the code for Filling Columns "C to D" from columns "A & B".
NB:- Data starts Row (2)
NB:- The previous filling Code is based on column "A" data, can you show that, and I try running the code using that.

Data Filling code:-

[COLOR=navy]Sub[/COLOR] MG27Jun43
[COLOR=navy]Dim[/COLOR] Rng        [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] Dn         [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] nRay       [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] n          [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] Dels       [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] Fd         [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] c          [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] Str        [COLOR=navy]As[/COLOR] [COLOR=navy]String[/COLOR]
[COLOR=navy]Dim[/COLOR] Col        [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] IsFd       [COLOR=navy]As[/COLOR] Boolean
[COLOR=navy]Dim[/COLOR] Twn [COLOR=navy]As[/COLOR] [COLOR=navy]String[/COLOR]
[COLOR=navy]Set[/COLOR] Rng = Range(Range("A2"), Range("A" & rows.Count).End(xlUp))
nRay = Array("01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20")
Col = 2
[COLOR=navy]For[/COLOR] [COLOR=navy]Each[/COLOR] Dn [COLOR=navy]In[/COLOR] Rng
    Dn = Trim(Dn): Dn.Offset(, 1) = Trim(Dn.Offset(, 1))
    Twn = Join(Application.Transpose(Application.Transpose(Dn.Resize(, 2))))
    Dels = Split(Twn, " ")
        [COLOR=navy]For[/COLOR] n = 0 To UBound(nRay)
            IsFd = False
              [COLOR=navy]For[/COLOR] Fd = 0 To 7
                  [COLOR=navy]If[/COLOR] nRay(n) = Dels(Fd) [COLOR=navy]Then[/COLOR]
                     IsFd = True
                     [COLOR=navy]Exit[/COLOR] For
                   [COLOR=navy]End[/COLOR] If
              [COLOR=navy]Next[/COLOR] Fd
                   [COLOR=navy]If[/COLOR] IsFd = False [COLOR=navy]Then[/COLOR]
                       c = c + 1
                       Str = Str & nRay(n) & " "
                       Col = IIf(Col = 5, 2, Col)
                            [COLOR=navy]If[/COLOR] c = 4 [COLOR=navy]Then[/COLOR]
                                Col = Col + 1
                                Cells(Dn.row, Col) = Str
                                Str = ""
                                c = 0
                            [COLOR=navy]End[/COLOR] If
                    [COLOR=navy]End[/COLOR] If
        [COLOR=navy]Next[/COLOR] n
[COLOR=navy]Next[/COLOR] Dn
[COLOR=navy]End[/COLOR] [COLOR=navy]Sub[/COLOR]

Randomize Data in "C to E" code:-

[COLOR=navy]Sub[/COLOR] MG27Jun43
[COLOR=navy]Dim[/COLOR] Rng    [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] Dn     [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] txt    [COLOR=navy]As[/COLOR] [COLOR=navy]String[/COLOR]
[COLOR=navy]Dim[/COLOR] c      [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] R      [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] n      [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] AcFray [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] Fray   [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] Rw     [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] t
[COLOR=navy]Set[/COLOR] Rng = Range("C2:C58")
[COLOR=navy]For[/COLOR] [COLOR=navy]Each[/COLOR] Dn [COLOR=navy]In[/COLOR] Rng
    [COLOR=navy]For[/COLOR] n = 1 To 3
        txt = txt & " " & Trim(Dn(, n))
    [COLOR=navy]Next[/COLOR] n
    [COLOR=navy]With[/COLOR] Application
        Fray = oRnd(.Transpose(.Transpose(Split(Mid(txt, 2), " "))))
    [COLOR=navy]End[/COLOR] With
    t = UBound(Fray)
    ReDim FinRay(1 To 3)
    txt = ""
    R = 0
[COLOR=navy]For[/COLOR] [COLOR=navy]Each[/COLOR] Rw [COLOR=navy]In[/COLOR] Fray
    c = c + 1
    txt = txt & " " & Rw
    [COLOR=navy]If[/COLOR] c Mod 4 = 0 [COLOR=navy]Then[/COLOR]
        R = R + 1
        FinRay(R) = Mid(txt, 2)
        txt = ""
    [COLOR=navy]End[/COLOR] If
[COLOR=navy]Next[/COLOR] Rw
Dn.Resize(, 3) = FinRay
[COLOR=navy]Next[/COLOR] Dn
[COLOR=navy]End[/COLOR] [COLOR=navy]Sub[/COLOR]
Function oRnd(ByRef ray [COLOR=navy]As[/COLOR] Variant) [COLOR=navy]As[/COLOR] Variant
[COLOR=navy]Dim[/COLOR] num    [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] n      [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] txt    [COLOR=navy]As[/COLOR] [COLOR=navy]String[/COLOR]
[COLOR=navy]Dim[/COLOR] Rw     [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] TxRay() [COLOR=navy]As[/COLOR] [COLOR=navy]String[/COLOR]
[COLOR=navy]Dim[/COLOR] c      [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] p      [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] rws    [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] nRay [COLOR=navy]As[/COLOR] Variant
ReDim nRay(1 To UBound(ray))
Randomize
rws = UBound(ray)
[COLOR=navy]For[/COLOR] Rw = 1 To rws
    c = 0: p = p + 1
      num = Int(Rnd * UBound(ray)) + 1
        nRay(p) = ray(num)
[COLOR=navy]For[/COLOR] n = 1 To UBound(ray)
    [COLOR=navy]If[/COLOR] Not ray(n) = ray(num) [COLOR=navy]Then[/COLOR]
        ReDim Preserve TxRay(c)
        TxRay(c) = n
        c = c + 1
    [COLOR=navy]End[/COLOR] If
[COLOR=navy]Next[/COLOR] n
ray = Application.Transpose(Application.Index(ray, Application.Transpose(Array(TxRay))))
[COLOR=navy]Next[/COLOR] Rw
oRnd = nRay
[COLOR=navy]End[/COLOR] Function

Regards Mick

 

[sezuh]

Thanks Mick,
the reason i changed from column "A" to "A:B" to see if its going to make any diffrerent having duplicate numbers,there isnt any from column"A" now but there duplicate numbers from column "B" repeated in Columns "C:E" here is aan example;
Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 87px"><COL style="WIDTH: 83px"><COL style="WIDTH: 83px"><COL style="WIDTH: 78px"><COL style="WIDTH: 73px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>01 02 03 05</TD><TD style="COLOR: #99cc00">04 06 11 17</TD><TD style="COLOR: #99cc00">16 12 11 15</TD><TD>08 07 13 09</TD><TD style="COLOR: #99cc00">10 17 06 14</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>01 02 04 20</TD><TD style="COLOR: #ff0000">03 05 10 16</TD><TD style="COLOR: #ff0000">11 15 06 16</TD><TD>12 07 17 13</TD><TD style="COLOR: #ff0000">10 14 08 09</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>01 02 06 08</TD><TD style="COLOR: #00ccff">03 04 09 17</TD><TD>11 07 18 14</TD><TD style="COLOR: #00ccff">17 13 19 16</TD><TD style="COLOR: #00ccff">09 15 10 12</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>01 02 07 15</TD><TD style="COLOR: #008080">03 04 08 10</TD><TD style="COLOR: #008080">14 08 11 17</TD><TD style="COLOR: #008080">19 16 10 12</TD><TD>13 18 20 09</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>01 02 09 17</TD><TD style="COLOR: #ff0000">03 04 05 07</TD><TD style="COLOR: #ff0000">04 11 10 05</TD><TD style="COLOR: #ff0000">07 06 12 15</TD><TD>13 14 08 16</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>01 02 10 11</TD><TD style="COLOR: #0066cc">03 07 14 17</TD><TD>15 16 19 06</TD><TD style="COLOR: #0066cc">13 18 14 05</TD><TD style="COLOR: #0066cc">12 09 08 17</TD></TR></TBODY></TABLE>
sezuh

 

[MickG]

I find that impossible!!
How are you runing this code ???, Try perhaps a CommandButton !!
This is some basic code to tell you if you have a duplicate number in any row.
When the msgbox shows if its blank there's no duplicates.
Try running after each of the other codes.
I've also copied you Column "A" data and run the codes with no dups !!!

[COLOR="Navy"]Sub[/COLOR] MG27Jun44
[COLOR="Navy"]Dim[/COLOR] Rng [COLOR="Navy"]As[/COLOR] Range, Dn [COLOR="Navy"]As[/COLOR] Range, n [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Ray, txt [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String,[/COLOR] c
[COLOR="Navy"]Set[/COLOR] Rng = Range(Range("A2"), Range("A" & rows.Count).End(xlUp))
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
Dn = Trim(Dn): Dn(, 2) = Trim(Dn(, 2)): Dn(, 3) = Trim(Dn(, 3)): Dn(, 4) = Trim(Dn(, 4))
Dn(, 5) = Trim(Dn(, 5))
txt = Join(Application.Transpose(Application.Transpose(Dn.Resize(, 5))))
Ray = Split(txt, " ")
[COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
.CompareMode = vbTextCompare
[COLOR="Navy"]For[/COLOR] n = 0 To UBound(Ray)
[COLOR="Navy"]If[/COLOR] Not .Exists(Ray(n)) [COLOR="Navy"]Then[/COLOR]
.Add Ray(n), ""
[COLOR="Navy"]Else[/COLOR]
c = c + 1
[COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR] n
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]Next[/COLOR] Dn
MsgBox c
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[sezuh]

hi,i dont know what to say but apologise for all this trouble,

How are you runing this code ???,

copy the code from your post>Alt+F11>Insert>Module>paste,Alt+F8
then Run the code.

Try perhaps a CommandButton !!

This out of my league ,i have never tried it and i dont know how to set it up.
The question is how you run the code without getting duplicate?that is what confusing me..?
Mick please,please accept my deepest apologies i have never intended to
give you so much hassle,i thought i would solve this with your first code but it did not..sorry......
thanks and kind regards
sezuh

 

[MickG]

Have a look at this file , its an example of the 2 data sets "B to E" and "C to E"
NoDups Hopefully.xls

If you want Command Buttons, you'll need the "Developers Tab" on Xl2007 Plus.
I've got something I wrote some time ago for Xl2003, but if you google it I'm sure you'l get a result.

 

[sezuh]

Mick,
Thanks for all your help and suggestions,i copied and saved "NoDups hopefully" workbook.i'll use it when i needed.
On my dayoff i'll google "Command Buttons" and see if i can grab something.....
As ever, i realy appreciate , all the help i get from this forum.
Kind regards
Sezuh