Duplicating rows with drop down menus based on number entered

[melliemel112]

Hello all. I am quite a novice to excel in many ways. Especially when it comes to formulas and functions.

I am working in a job where I have to process paperwork for people. to have I am trying to create a spreadsheet that can be used for 1 or many based upon the value entered in.

Here is the set-up: (row and column values reflect how they're set up on my sheet)
- I want to be able to enter a value in B9, which will indicate how many people will be visiting for that specific event.
- The value entered in B9 will have represent the total times the requested information in A14:I14 (row 14 has the headers for the information requested while row 15 has the drop down lists (A and B contain the drop down) to be replicated.

I would like to be able to have X number of rows created where X=B9.

I hope that is clear enough.

There will be information requested below those entries. So if there is something else I need to ensure that I do to easily shift everything down based on the entries that would be great.

Cheers!

Melanie

[kersplash]

Can you attach a sample workbook with mock expected outcomes?

[melliemel112]

Here you go. I think. I should have put that in initially.

So if 5 people are coming, the row will replicate 5 times and shift anything below that down.

Thank you!