VBA/Macro to insert rows based on drop downlist selection

[FONT=&quot]Hi[/FONT]
[FONT=&quot]I'm not sure how or get this to work.[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]I have attached a file[/FONT]
[FONT=&quot]Thanks in advance
JetView attachment Test 1 VBA.xls[/FONT]

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/vba-macro-to-insert-rows-based-on-drop-downlist.45283/
VBA/Macro to insert rows based on drop downlist selection
http://www.vbaexpress.com/forum/sho...-insert-rows-based-on-drop-downlist-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

[FONT=&quot]My apologies[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]The following site have the same question added:[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]1. https://www.myonlinetraininghub.com...-rows-based-on-drop-downlist-selection#p17348[/FONT]
[FONT=&quot]2. https://chandoo.org/forum/threads/vba-macro-to-insert-rows-based-on-drop-downlist.45283/ [/FONT]
[FONT=&quot]3. https://www.ozgrid.com/forum/index....insert-rows-based-on-drop-downlist-selection/[/FONT]
[FONT=&quot]4. http://www.vbaexpress.com/forum/sho...-insert-rows-based-on-drop-downlist-selection[/FONT]
[FONT=&quot]5. https://www.mrexcel.com/board/threa...drop-downlist-selection.1150787/#post-5585077[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Hope thats all the sites.[/FONT]