Macro: Drop Down Menu Selection Inserts Templated Rows

[nealshah4]

Hey guys,

I was hoping someone could help me out with some VBA code! Basically, I would like to create a drop down menu that identifies a number of "selections" (through data validation) and inserts templated rows (from another sheet) for every "selection". For example, if "3 Selections" is chosen in the drop down, 3 sets of templated rows are inserted beneath. I would appreciate any help! Thanks.

[realniceguy5000]

Hi,

Could you post an example workbook of your data?

...

[nealshah4]

Attached is a sample workbook that I created for purposes of this Macro as I cannot attach the actual data I am working with. Basically, in Row 3 in the "Pricing Module" worksheet, you can select a number from 1-20. Based on that selection, I would like Rows 5:27 on the "Templated Rows" worksheet to be repeated (going down) however many times is selected. For sake of this example, I have copied and pasted how the "Pricing Modules" worksheet should look after the Macro has run for a "3" selection. Thanks in advance for any help you can offer!

[realniceguy5000]

Maybe you could try this: Goes in the sheet code that the drop down box is on.

Please Login or Register  to view this content.

[nealshah4]

Thank you so much for your help, I truly appreciate it! Can you clarify what "Goes in the sheet code that the drop down box is on" means a bit? Based on the code, I believe this will serve my purpose, just a bit unsure of how to embed the code in the drop down box!

[jaslake]

Hi nealshah4

From looking at your code, I suspect this is more of what you're looking for.

Please Login or Register  to view this content.

To insert the code:

1. Copy the code
2. Right click on sheet tab "Pricing Module"
3. Select "View Code"
4. Paste the code into the window on the right
5. Code will run when you change Cell B3 of Pricing Module

Code is in the attached. Let me know of issues.