creator007
New Member
- Joined
- Jun 29, 2010
- Messages
- 23
Hello Mr. Excel Forum Members,
This seems easy but I can't figure it out. I have a list of dollar sales for several divisions and the divisions are listed by numbers. I want to be able to input the division number and the list of sales will populate. Can you please help?
<table border="0" cellpadding="0" cellspacing="0" width="559"><col style="mso-width-source:userset;mso-width-alt:6070;width:125pt" width="166"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:1974; width:41pt" span="2" width="54"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:125pt" height="17" width="166">
</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> <td style="width:66pt" width="88">Division (data)</td> <td style="width:52pt" width="69">
</td> <td style="width:41pt" width="54">
</td> <td style="width:41pt" width="54">
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Divison (Input division here)</td> <td class="xl67"> </td> <td>
</td> <td class="xl66">1</td> <td class="xl66">2</td> <td class="xl66">3</td> <td class="xl66">4</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 12.00 </td> <td class="xl65"> $ 1.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 25.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $16.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 22.00 </td> <td class="xl65"> $ 18.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $33.00 </td> </tr> </tbody></table>
This seems easy but I can't figure it out. I have a list of dollar sales for several divisions and the divisions are listed by numbers. I want to be able to input the division number and the list of sales will populate. Can you please help?
<table border="0" cellpadding="0" cellspacing="0" width="559"><col style="mso-width-source:userset;mso-width-alt:6070;width:125pt" width="166"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:1974; width:41pt" span="2" width="54"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:125pt" height="17" width="166">
</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> <td style="width:66pt" width="88">Division (data)</td> <td style="width:52pt" width="69">
</td> <td style="width:41pt" width="54">
</td> <td style="width:41pt" width="54">
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Divison (Input division here)</td> <td class="xl67"> </td> <td>
</td> <td class="xl66">1</td> <td class="xl66">2</td> <td class="xl66">3</td> <td class="xl66">4</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 12.00 </td> <td class="xl65"> $ 1.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 25.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $ 50.00 </td> <td class="xl65"> $16.00 </td> <td class="xl65"> $50.00 </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td class="xl65"> $ 22.00 </td> <td class="xl65"> $ 18.00 </td> <td class="xl65"> $50.00 </td> <td class="xl65"> $33.00 </td> </tr> </tbody></table>