Excel Automation

[nagd1986]

Hi here is my question. how can i take a report full of data on one tab and then create a list on another where it would only pull specific lines?


<table width="509" border="0" cellpadding="0" cellspacing="0" height="580"><col style="mso-width-source:userset;mso-width-alt:23040;width:473pt" width="630"> <col style="mso-width-source:userset;mso-width-alt:5412; width:111pt" span="2" width="148"> <tbody><tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt;width:473pt" width="630" height="17">
</td> <td class="xl65" style="width:111pt" width="148"> 2011 </td> <td class="xl65" style="width:111pt" width="148"> 2011 </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65"> GAAP </td> <td class="xl65"> GAAP </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65"> USD: US DOLLAR </td> <td class="xl65"> USD: US DOLLAR </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65"> P4100. Group Insurance Segment </td> <td class="xl65"> P4100. Group Insurance Segment </td> </tr> <tr style="height:51.0pt" height="68"> <td class="xl65" style="height:51.0pt" align="left" height="68">
</td> <td class="xl66" style="width:111pt" width="148"> BANKING </td> <td class="xl66" style="width:111pt" width="148"> MORTGAGE </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65"> FYTD MARCH </td> <td class="xl65"> FYTD MARCH </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65"> C0000: TOTAL COUNTER-PARTY BY LEGAL ENTITY </td> <td class="xl65"> C0000: TOTAL COUNTER-PARTY BY LEGAL ENTITY </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65"> P1000: Total Consolidated </td> <td class="xl65"> P1000: Total Consolidated </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65"> S0000: SOURCE VIEW TOP </td> <td class="xl65"> S0000: SOURCE VIEW TOP </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" align="left" height="17">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="left" height="17"> 45009: PREMIUM FIRST YEAR COLLECTED-DIRECT-WAIVER DUE TO DISABILITY</td> <td class="xl67">0 </td> <td class="xl67">0 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="left" height="17"> E4233: Premium First Year Collected - Direct - Scheduled</td> <td class="xl67">0 </td> <td class="xl67">0 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="left" height="17"> E4238: Premiums - first year - collected - direct</td> <td class="xl67">0 </td> <td class="xl67">0 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="left" height="17"> E4237: Premiums - first year - collected - direct</td> <td class="xl67">0 </td> <td class="xl67">0 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="left" height="17"> 45025: AFFIL FIRST YEAR PREMIUMS - GROUP CONVERSIONS - DUE & UNPAID DIRECT</td> <td class="xl67">0 </td> <td class="xl67">0 </td> </tr> </tbody></table>