im a rookie with excel know how to do basic calculations but not very good with formatting.
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 category and above the next category. im pretty sure this is possible. that is on one sheet with all categories.
i also want to have each category on a separate sheet. and when the master list of all categories changes i want to other sheets to change as well.
example.xlsx
im not sure how to do this with how the changin original master sheet.
i attached an example sheet. not the whole thing just a few categories to see my structure.
thanks
Bookmarks