Multiple filtered drop downs

[Val68]

Hi! Here's my problem: I have a file containing multiple columns with headers:
A - State
B - City
C - Address
D - Zip Code.
E - Full name
The number of lines is currently 5000, but they keep growing.
I have created another tab containing a simple form without using VBA. This is what I want to do: when selecting State in cell A1, the drop down in C1 should list all cities from that state. When selecting a certain city, it should list all related addresses in E1. Last, when selecting an address, it should show the zip code and name (this can be done with VLOOKUP).
I've found some solutions, but they ask for all regions and cities to be listed, which needs thousands of columns. As I said, what I have is a dynamic set of data. What I want is a bunch of drop downs that filter data existing in the actual table. I hope I gave you an idea. Thank you in advance for your help!

 

[Rijnsent]

Hi Val68,
I'd have a look at Slicers (e.g. Excel Slicers - Introduction, what are they, how to use them, tips, advanced concepts, interactive charts & reports using Slicers & Pivot Tables ). Using your table as a data source (assuming you set your data as a Table as that will auto-include new records), create a pivot table on the second sheet and add some slicers.
Hope that gets you started,
Koen