999HelpPlease
New Member
- Joined
- Jul 16, 2014
- Messages
- 35
I have a worksheet that consists of a complete database and I want to create a summarized worksheet. The summarized worksheet will be based on the State that is selected from a drop down list. Here is a sample of the database. So if in the summarized worksheet I selected the state FL, I would have three rows of information listed one under the other. My database is quite large and this is just a reference. Can you let me know what the programming would be to write this? Thank you for your help.[TABLE="width: 500"]
<tbody>[TR]
[TD]Plan[/TD]
[TD]State[/TD]
[TD]Type[/TD]
[TD]Code[/TD]
[TD]Model[/TD]
[TD]Discount[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Federal[/TD]
[TD]FL[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Federal[/TD]
[TD]AK[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]State[/TD]
[TD]AK[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Local[/TD]
[TD]FL[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Local[/TD]
[TD]OR[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]91[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]State[/TD]
[TD]FL[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Plan[/TD]
[TD]State[/TD]
[TD]Type[/TD]
[TD]Code[/TD]
[TD]Model[/TD]
[TD]Discount[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Federal[/TD]
[TD]FL[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Federal[/TD]
[TD]AK[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]State[/TD]
[TD]AK[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Local[/TD]
[TD]FL[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Local[/TD]
[TD]OR[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]91[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]State[/TD]
[TD]FL[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]