automatik47
New Member
- Joined
- Jul 2, 2008
- Messages
- 2
<table x:str="" style="border-collapse: collapse; width: 530px; height: 144px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 50pt;" span="3" width="66"> <col style="width: 50pt;" width="66"> <col style="width: 50pt;" width="66"> <col style="width: 50pt;" width="67"> <col style="width: 50pt;" width="66"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl32" style="height: 12.75pt; width: 48pt;" width="64" height="17">Apples</td> <td class="xl30" style="width: 50pt;" x:num="1" width="66"> 1 </td> <td class="xl30" style="border-left: medium none; width: 50pt;" x:num="1" width="66"> 1 </td> <td class="xl30" style="border-left: medium none; width: 50pt;" x:num="1" width="66"> 1 </td> <td class="xl30" style="border-left: medium none; width: 50pt;" x:num="2" width="66"> 2 </td> <td class="xl30" style="border-left: medium none; width: 50pt;" x:num="2" width="66"> 2 </td> <td class="xl30" style="border-left: medium none; width: 50pt;" x:num="0" width="67"> - </td> <td class="xl30" style="border-left: medium none; width: 50pt;" x:num="1" width="66"> 1 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl32" style="height: 12.75pt;" height="17">Oranges</td> <td class="xl31" style="border-top: medium none;" x:num="9"> 9 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="7"> 7 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="7"> 7 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="10"> 10 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="8"> 8 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="7"> 7 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="7"> 7 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl32" style="height: 12.75pt;" height="17">Mangos</td> <td class="xl30" style="border-top: medium none;" x:num="17"> 17 </td> <td class="xl30" style="border-top: medium none; border-left: medium none;" x:num="13"> 13 </td> <td class="xl30" style="border-top: medium none; border-left: medium none;" x:num="13"> 13 </td> <td class="xl30" style="border-top: medium none; border-left: medium none;" x:num="18"> 18 </td> <td class="xl30" style="border-top: medium none; border-left: medium none;" x:num="14"> 14 </td> <td class="xl30" style="border-top: medium none; border-left: medium none;" x:num="14"> 14 </td> <td class="xl30" style="border-top: medium none; border-left: medium none;" x:num="13"> 13 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl32" style="height: 12.75pt;" height="17">Donkies</td> <td class="xl31" style="border-top: medium none;" x:num="25"> 25 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="19"> 19 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="19"> 19 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="26"> 26 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="20"> 20 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="21"> 21 </td> <td class="xl31" style="border-top: medium none; border-left: medium none;" x:num="19"> 19
</td> </tr> </tbody></table>This is the data i have on one sheet 1 per say. On sheet 2 I have
Apples
Oranges
Mangos
Donkies
I need all the numbers copied to sheet 2 from sheet 1 and look exactly like sheet 1. I am dealing with huge amount of data and I need a find and copy function. I have a very minimal knowledge of VBA so any code will be helpful...Thank you very much
</td> </tr> </tbody></table>This is the data i have on one sheet 1 per say. On sheet 2 I have
Apples
Oranges
Mangos
Donkies
I need all the numbers copied to sheet 2 from sheet 1 and look exactly like sheet 1. I am dealing with huge amount of data and I need a find and copy function. I have a very minimal knowledge of VBA so any code will be helpful...Thank you very much
Last edited: