Jet Fusion
11-11-2020, 12:14 AM
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
Jet27424
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
Jet27424