Hello!

Does anyone know a way of creating dynamic/dependant drop down data validation lists with vba? E.g a data validation list in one cell will differ depending on what is in another cell.

I know this is possible with formulas and source tables etc. but I really want to avoid cluttering my workbook with source tables - i'd like it to all work behind the scenes with code!

I'd really appreciate any help or suggestions!

Thanks!