VBA/Macro to insert rows based on drop downlist selection

[Jet Fusion]

Hi
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 a border around the 3 rows everytime it get inserted and the the two of the rows should have info based on the name that was selected from the drop down list.
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. So every 3rd row will have a dropdown list.
I have attached a file
Thanks in advance
JetTest 1 VBA.xls

[Jet Fusion]

My apologies


The following site have the same question added:


1. https://www.myonlinetraininghub.com/...lection#p17348
2. https://chandoo.org/forum/threads/vb...ownlist.45283/
3. https://www.ozgrid.com/forum/index.p...ist-selection/
4. https://www.excelguru.ca/forums/showthread.php?10920-VBA-Macro-to-insert-rows-based-on-drop-downlist-selection
5. https://www.mrexcel.com/board/thread.../#post-5585077


Hope thats all the sites.

[jolivanes]

Re: Hope thats all the sites.
Do you want us to go and check all these sites to see if someone has used their hard to get free time to help you and then see if there might be a site that you forgot?

[snb]

Yes, this is a very interesting question.

[Jet Fusion]

Could one of the mods kindly remove this thread?