Making cells dynamic

[NaomiDawn]

Promotions Example.xlsx

Hi,

I have a spreadsheet that i'm wanting to send out to a lot of people.

I have attached the spreadsheet.

Instead of having 7 different boxes that they could type into - i want to make it so that if they type into one, another below appears, so that it doesnt take up all of that space if say they only wanted to add two promotions. Does this make sense? There could be from 1 promotion to 30 promotions.

Naomi