I use an Excel sheet to capture brainstormed ideas, and then break down the
tasks involved.

I have it set up now where, say, A2:A4 is a merged cell for the idea, and
B2, B3, and B4 are bordered off for the tasks. C2, C3, and C4 have list boxes
for priorities and D2, D3, and D4, have list boxes for to whom the task is
assigned.

Trouble is, some ideas need two tasks, some need four (or more).

I'd like to have the user fill in cell A2 with the idea (I have it on
AutoFit if they're verbose), and then B2 for the first task, C2 with the
priority box, and D2 with the assigned employee.

If there is a second task to be added to that idea, I'd like there to be an
"Add New Task" button, which will:
i) add B3 for a new task
ii) add C3 with the proper list-picking validation
iii) add D3 with the proper list-picking validation
iv) merge A2 with A3 so it's all one big master row.

.... and so on.

Thoughts?