I'm building a list of questions and these questions are compiled under about 10 different categories. what i am trying to do is have this list be adaptable so that if i want to add more questions in a catagory the catagory expands and adds a blank space below the last question in the category.
i also want to have each category on a separate sheet which adjusts when I work on the master sheet
example.xlsx
i attached an example sheet. not the whole thing just a few categories to see my structure.
thanks
Bookmarks