Hi,

I am having some difficulties in making this template for my boss so can someone please give me a hand on this?

This is the situation:

I need to create a drop list and when I select the drop list, it will give me a few selections for example: Sports, News, Music. (This I can do). On the right side of the cell, i will have week 1, week 2 all the way to 25.

Once I select Sports, the data from the Sports section will appear in the next few cells such as basketball, baseball, tennis and so on along with the data in week 1, 2, ... etc There will be an empty cell right below the row of the drop list cell that will allow me to input a new type of sport as well as add data to the week 1, 2, columns.

Once it has been added, this new sport will be saved under the Sports section.

I hope this is clear enough!