srinath1611
New Member
- Joined
- Aug 17, 2010
- Messages
- 27
Hi
I have an excel sheet which is mentioned below.
<table width="1208" border="0" cellpadding="0" cellspacing="0" height="432"><col style="width: 48pt;" width="64"> <col style="width: 30pt;" width="40" span="22"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" width="64" height="17">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td style="width: 30pt;" valign="top" width="40" align="left"> <table cellpadding="0" cellspacing="0"> <tbody><tr> <td class="xl24" style="height: 12.75pt; width: 30pt;" width="40" height="17">
</td> </tr> </tbody></table>
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">Supplier</td> <td class="xl29">XYZ</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 25.5pt;" height="34"> <td class="xl26" style="height: 25.5pt;" height="34">Material</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 1</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 2</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 3</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 4</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 5</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 6</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 7</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 8</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 9</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 10</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 11</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 12</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 13</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 14</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 15</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 16</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 17</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 18</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 19</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 20</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 21</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 22</td> <td class="xl27" style="border-left: medium none; width: 48pt;" width="64">Total Qty</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="border-top: medium none; height: 12.75pt;" height="17">A</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">x</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">70</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">B</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">300</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">C</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">400</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">D</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">200</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">E</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">F</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="23" class="xl30" style="height: 12.75pt;" height="17">Total Qty</td> <td class="xl28" style="border-left: medium none;">1100</td> </tr> </tbody></table>
I have a command button called 'SAVE'. When I click on the button, I am looking for a report which should include
Supplier, Total qty in a separate worksheet.
Supplier is in the cell 'B2'
Total qty is in the cell 'X22'
When the file is closed in between, the macro should remember the row number and should start inserting the new records after re-opening the file.
Can some one help me in this regard. I am looking for a macro.
Thanks
I have an excel sheet which is mentioned below.
<table width="1208" border="0" cellpadding="0" cellspacing="0" height="432"><col style="width: 48pt;" width="64"> <col style="width: 30pt;" width="40" span="22"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" width="64" height="17">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td class="xl24" style="width: 30pt;" width="40">
</td> <td style="width: 30pt;" valign="top" width="40" align="left"> <table cellpadding="0" cellspacing="0"> <tbody><tr> <td class="xl24" style="height: 12.75pt; width: 30pt;" width="40" height="17">
</td> </tr> </tbody></table>
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">Supplier</td> <td class="xl29">XYZ</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 25.5pt;" height="34"> <td class="xl26" style="height: 25.5pt;" height="34">Material</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 1</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 2</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 3</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 4</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 5</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 6</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 7</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 8</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 9</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 10</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 11</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 12</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 13</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 14</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 15</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 16</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 17</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 18</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 19</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 20</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 21</td> <td class="xl27" style="border-left: medium none; width: 30pt;" width="40">Factor 22</td> <td class="xl27" style="border-left: medium none; width: 48pt;" width="64">Total Qty</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="border-top: medium none; height: 12.75pt;" height="17">A</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">x</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">70</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">B</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">300</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">C</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">400</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">D</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">200</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">E</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">80</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> <td class="xl25">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl28" style="height: 12.75pt;" height="17">F</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">x</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">
</td> <td class="xl28" style="border-left: medium none;">50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td colspan="23" class="xl30" style="height: 12.75pt;" height="17">Total Qty</td> <td class="xl28" style="border-left: medium none;">1100</td> </tr> </tbody></table>
I have a command button called 'SAVE'. When I click on the button, I am looking for a report which should include
Supplier, Total qty in a separate worksheet.
Supplier is in the cell 'B2'
Total qty is in the cell 'X22'
When the file is closed in between, the macro should remember the row number and should start inserting the new records after re-opening the file.
Can some one help me in this regard. I am looking for a macro.
Thanks