Wednesday, May 18, 2011

Cascading Validation Drop Down Lists in Excel

Tony(?) asked in class about enhancing Validation Drop Down Lists in Excel so that he could use a cascading set of three Drop Down Lists. The article hyperlink explains how to do this.

in reference to: http://www.bluepecan.co.uk/excel_training_cascading_drop_down_lists_using_data_validation.html (view on Google Sidewiki)

1 comment:

s.lansbury said...

Hi Ananda,
It was me that asked about this, thanks so much for finding and posting a link to the method.

As we discussed I needed to use this for three levels of lists, it's taken me a long time to populate all the data but it works!

I liked the tip at the end of using the substitute function, I searched and found how to use multiple substitutes together as I need to replace spaces with underscores, ampersand with and, and remove commas.

This is going to be great for the data collection we're doing at the moment. Once again, thanks!