Hi all, I need help figuring out how to insert rows in between other rows. I keep a locomotive periodic maintenance report, I have 3 rows and each row is for each locomotive one underneath the other. I need to be able to insert a row below each piece of equipment. I have a code that will do just that but it only works a few times and then starts inserting rows where I don't need it. I'm very new at this and do not know all the proper terminology. Please see example below. My problem is when hit command button a few times it will only insert new lines below the 601 and 602. I need continuous data therefore I need to keep inserting lines below the 601, 602, 603. Thanks in advance! The Data spans from Column b to column T and rows 14 15 and 16.
Beginning before I hit the command button
<tbody>
</tbody>
After I hit the command button
<tbody>
</tbody>
Beginning before I hit the command button
601 | 10/17/2018 | 1/16/2019 | 4/6/2019 | 4/26/2018 | 4/17/2019 | 4/26/2017 | 1/17/2018 | 1/16/2019 | 1/17/2018 | 1/16/2019 | 1/17/2018 | 1/16/2019 | 4/5/2017 | |||||
602 | 11/7/2018 | 2/5/2019 | 5/1/2019 | 6/6/2018 | 6/6/2019 | 6/6/2018 | 2/7/2018 | 2/5/2019 | 2/7/2018 | 2/5/2019 | 2/7/2018 | 2/5/2019 | 4/4/2017 | 5/1/2019 | ||||
603 | 12/5/2018 | 3/6/2019 | 6/5/2019 | 8/3/2019 | 8/2/2016 | 2/7/2018 | 3/6/2019 | 3/7/2018 | 3/6/2019 | 3/7/2018 | 3/6/2019 | 4/3/2017 | 6/5/209 |
<tbody>
</tbody>
After I hit the command button
601 | 10/17/2018 | 1/16/2019 | 4/6/2019 | 4/26/2018 | 4/17/2019 | 4/26/2017 | 1/17/2018 | 1/16/2019 | 1/17/2018 | 1/16/2019 | 1/17/2018 | 1/16/2019 | 4/5/2017 | |||||
4/17/2019 | 1/16/2019 | 1/16/2019 | 1/16/2019 | |||||||||||||||
602 | 11/7/2018 | 2/5/2019 | 5/1/2019 | 6/6/2018 | 6/6/2019 | 6/6/2018 | 2/7/2018 | 2/5/2019 | 2/7/2018 | 2/5/2019 | 2/7/2018 | 2/5/2019 | 4/4/2017 | 5/1/2019 | ||||
6/6/2019 | 2/5/2019 | 2/5/2019 | 2/5/2019 | 5/1/2019 | ||||||||||||||
603 | 12/5/2018 | 3/6/2019 | 6/5/2019 | 8/3/2019 | 8/2/2016 | 2/7/2018 | 3/6/2019 | 3/7/2018 | 3/6/2019 | 3/7/2018 | 3/6/2019 | 4/3/2017 | 6/5/2019 | |||||
3/6/2019 | 3/6/2019 | 3/6/2019 | 6/5/2019 |
<tbody>
</tbody>