Hi there,
I have a huge dataset which is basically a list of categories and sub categories. I am trying to create a form in which the user can select the appropriate categories - the content in each dropdown menu needs to change depending on the item selected in the preceding dropdown. I'm not sure how to do this - can someone help? I've attached a sample workbook - the category set is on the Categories tab and the Form (where the dropdowns are) is on the Form tab.
sample workbook - categories.xlsx
Thanks
Bookmarks