• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA/Macro to insert rows based on drop downlist

Jet Fusion


I'm not sure how or get this to work.

I would like to add 3 rows based on a selection from a drop down list or would it be better to use a macro to ask which selection/name and then to insert 3 rows.

Once the rows have been inserted the firs row should be the Name that was selcted in bold and the the two rows should have info based on the name that was selected.

There will be a list of different selections so would it be better to make a data sheet and then the info can be autofilled to the specific rows.

Also everytime you make a selection the 3 rows that get added will have to continue from the last row that was added.

I have attached a file

Thanks in advance


Last edited:


Excel Ninja
Jet Fusion
You are asking VBA Macros in Ask an Excel Question Forum.
Please, reread Forum Rules ...

How to get the Best Results at Chandoo.org
Please post, new posts in the correct forums,...