Change Display Range Based On Change of Dropdown Values

[Charles]

Hi,

I used a Worksheet Change event for this.
Any time you change the selection the data in the desired location with change.
If you want to see all of the data you look at the code and then create another code that will display the
Data. Or select "Caustic" and you will see all ot data. you can then change it if you wish.