Hi, can anyone suggest what is the best approach to tackle what I'm trying to accomplish? I have 8 columns of header and 132 rows of data per month starting January. I want to create on a separate sheet a dashboard so that the user can use a dropdown list to select 'Month' and another dropdown list to select 'Area', another dropdown list for 'Sub-Area' and another dropdown list for 'Type'. Based on these selections, it will search the database and produce data that results in Sales, Active, HPI, & 1yr Change. Here is a sample chart below.
<tbody>
</tbody>
Thank you in advance.
Month | Area | Sub-Area | Type | Sales | Active | HPI | 1 yr Change |
January | Area1 | Burke Mountain | Detach | 10 | 73 | $1,495,900 | 19.7% |
January | Area1 | Burke Mountain | Townhouse | 5 | 5 | $831,200 | 21.0% |
January | Area1 | Burke Mountain | Condo | 0 | 0 | $0 | 0.0% |
January | Area2 | Canyon Springs | Condo | 5 | 2 | $485,400 | 32.7% |
January | Area2 | Cape Horn | Detach | 1 | 7 | $1,055,900 | 16.8% |
January | Area3 | Cape Horn | Townhouse | 0 | 0 | $0 | 0.0% |
January | Area3 | Cape Horn | Condo | 0 | 0 | $0 | 0.0% |
February | Area1 | Westwood Plateau | Condo | 5 | 10 | $566,800 | 26.9% |
February | Area1 | Westwood Summit CQ | Condo | 0 | 0 | $0 | 0.0% |
February | Area2 | Birchland Manor | Detach | 2 | 0 | $914,000 | 16.3% |
February | Area2 | Central Pt Coquitlam | Detach | 0 | 13 | $829,800 | 15.5% |
March | Area1 | North Coquitlam | Detach | 0 | 2 | $0 | 0.0% |
March | Area1 | Park Ridge Estates | Detach | 1 | 1 | $1,410,000 | 14.4% |
March | Area2 | Ranch Park | Detach | 4 | 17 | $1,211,300 | 14.6% |
March | Area2 | River Springs | Detach | 1 | 0 | $861,200 | 13.5% |
<tbody>
</tbody>
Thank you in advance.