I have sheet where data is depend on another cells
In A column data is A b C D
In B column A1, A2, A3 is Related with A
In B column B1, B2, B3 is Related with B
In B column C1, C2, C3 is Related with C
In C Column A101, A102, A103 is Related with A1
In C Column A201, A202, A203 is Related with A2
In C Column A301, A302, A303 is Related with A3
In C Column B101, B102, B103 is Related with B1
In C Column B201, B202, B203 is Related with B2
Like that
So I need Droapdown For that Which will dependant on Eash Other
If I select A1 in B column then A101, A102, A103 should not appear in C columns dropdownlist
Please find attached sheet
Bookmarks