How to make a dropdown unclickable until a value from another dropdown is chosen, and use that value to filter the dropdown in Excel and Pandas

So I have an excel file that I generated with pandas that has a sheet with two columns A and B that are dropdowns (The values of those dropdowns are coming from another sheet in the same excel file), I want B to be unclickable for any row until A has been filled for any row. And after that, I want the value in A to be used to filter the dropdown in B. Does anyone have an idea how to go about it? This help will be greatly appreciated

Back to Top