Hey Guys, am seroiusly stack.
Am doin a serial number issuer for ma company.
<table style="border-collapse: collapse; width: 501px; height: 280px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="4" width="64"> <col style="width: 58pt;" span="2" width="77"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 48pt;" height="20" width="64"> </td> <td class="xl65" style="width: 48pt;" width="64"> </td> <td class="xl66" style="width: 48pt;" width="64"> </td> <td class="xl65" style="width: 48pt;" width="64"> </td> <td class="xl65" style="width: 58pt;" width="77"> </td> <td class="xl65" style="width: 58pt;" width="77"> </td> <td class="xl65" style="width: 48pt;" width="64"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl67">PackSize</td> <td class="xl67" style="border-left: medium none;">#Labels</td> <td class="xl68" style="width: 48pt;" width="64"> </td> <td class="xl69" style="width: 58pt;" width="77">Serial From</td> <td class="xl70" style="border-left: medium none;">Serial t0</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">2</td> <td class="xl65" align="right">250</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000001</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right">0000000251</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">5</td> <td class="xl65" align="right">80</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000252</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right"> 0000000332</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">2</td> <td class="xl65" align="right">500</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000333</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right">0000000833</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">2</td> <td class="xl65" align="right">250</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000834</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right">0000001084</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl73">
</td> <td class="xl73"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl74">Totol</td> <td class="xl74" align="right">1080</td> <td class="xl71"> </td> <td class="xl75" style="border-top: medium none;"> </td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> </tbody></table>
dont know how to upload the xls but roughly this is it.
important in the number of labels,the starting and end serials.
i want to send this data in a way that each row here sends data to another sheet with serials from start all the way to the end, this should be done for each row here till the last data row. that is on the second sheet i expect to have 1080 rows of data.
please somebody
Regards
Qnatz
Am doin a serial number issuer for ma company.
<table style="border-collapse: collapse; width: 501px; height: 280px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="4" width="64"> <col style="width: 58pt;" span="2" width="77"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 48pt;" height="20" width="64"> </td> <td class="xl65" style="width: 48pt;" width="64"> </td> <td class="xl66" style="width: 48pt;" width="64"> </td> <td class="xl65" style="width: 48pt;" width="64"> </td> <td class="xl65" style="width: 58pt;" width="77"> </td> <td class="xl65" style="width: 58pt;" width="77"> </td> <td class="xl65" style="width: 48pt;" width="64"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl67">PackSize</td> <td class="xl67" style="border-left: medium none;">#Labels</td> <td class="xl68" style="width: 48pt;" width="64"> </td> <td class="xl69" style="width: 58pt;" width="77">Serial From</td> <td class="xl70" style="border-left: medium none;">Serial t0</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">2</td> <td class="xl65" align="right">250</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000001</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right">0000000251</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">5</td> <td class="xl65" align="right">80</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000252</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right"> 0000000332</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">2</td> <td class="xl65" align="right">500</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000333</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right">0000000833</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65" align="right">2</td> <td class="xl65" align="right">250</td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;" align="right">0000000834</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="right">0000001084</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl65"> </td> <td class="xl65"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl73"> </td> <td class="xl73"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl73">
</td> <td class="xl73"> </td> <td class="xl71"> </td> <td class="xl72" style="border-top: medium none;"> </td> <td class="xl72" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20"> </td> <td class="xl74">Totol</td> <td class="xl74" align="right">1080</td> <td class="xl71"> </td> <td class="xl75" style="border-top: medium none;"> </td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65"> </td> </tr> </tbody></table>
dont know how to upload the xls but roughly this is it.
important in the number of labels,the starting and end serials.
i want to send this data in a way that each row here sends data to another sheet with serials from start all the way to the end, this should be done for each row here till the last data row. that is on the second sheet i expect to have 1080 rows of data.
please somebody
Regards
Qnatz