VBA/Macro to insert rows based on drop downlist selection

JetFusion

New Member
Joined
Apr 20, 2016
Messages
7
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
Jet

Also asked here https://www.myonlinetraininghub.com...-rows-based-on-drop-downlist-selection#p17348
here VBA/Macro to insert rows based on drop downlist selection
here VBA/Macro to insert rows based on drop downlist
here VBA/Macro to insert rows based on drop downlist selection
and here VBA/Macro to insert rows based on drop downlist selection - OzGrid Free Excel/VBA Help Forum
 

Attachments

  • VBA TEST 1.PNG
    VBA TEST 1.PNG
    7.3 KB · Views: 13
Last edited by a moderator:

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,122,710
Messages
5,597,702
Members
414,164
Latest member
ARTW

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top