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

[p45cal]

cross posted without links:

VBA/Macro to insert rows based on drop downlist | Chandoo.org Excel Forums - Become Awesome in Excel
https://chandoo.org/forum/threads/vb...ownlist.45283/
VBA/Macro to insert rows based on drop downlist selection
http://www.vbaexpress.com/forum/show...list-selection

Jet Fusion, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

[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. http://www.vbaexpress.com/forum/show...list-selection
5. https://www.mrexcel.com/board/thread.../#post-5585077


Hope thats all the sites.