Hi all, hoping someone can help with this one. I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or internal), then drop-down list column K to select the provider based on whether it's internal or external. For the life of me I can't get this to work and I'm not sure why, the drop down arrow comes up in column K but the list won't open.
I've set up the data for other drop-down lists as named ranges, and added formulas to make them dynamic (so that if anyone adds more providers it will automatically update this in the drop down options). The data for these lists are also kept on a separate tab called "Column Filters". Not sure if either of these factors may also affect what I'm doing?
I'll attach screenshots showing the current set up, any help would be greatly appreciated!
I've set up the data for other drop-down lists as named ranges, and added formulas to make them dynamic (so that if anyone adds more providers it will automatically update this in the drop down options). The data for these lists are also kept on a separate tab called "Column Filters". Not sure if either of these factors may also affect what I'm doing?
I'll attach screenshots showing the current set up, any help would be greatly appreciated!
