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.
<tbody>
</tbody>
Plan | State | Type | Code | Model | Discount | Number |
Federal | FL | 1 | 1 | 1 | 2 | 3 |
Federal | AK | 2 | 3 | 4 | 6 | 9 |
State | AK | 5 | 6 | 5 | 5 | 6 |
Local | FL | 1 | 2 | 3 | 5 | 6 |
Local | OR | 2 | 2 | 8 | 91 | 1 |
State | FL | 3 | 2 | 5 | 9 | 1 |
<tbody>
</tbody>