enggirl712
New Member
- Joined
- Jun 2, 2016
- Messages
- 3
Hi Everyone,
I am trying to find a code that will allow me to insert a new line below a selected cell, merge the cells of the new inserted line and the cell above it for column B only, and copy the equation of column C into the new row line using a button. I have the button set up and a code to insert a new line but I can't get any further. If you could help me that would be wonderful.
Example:
Insert Line below ItemA1, Merge PriceB2 and empty cell below it and copy equation from D2 to D3
<tbody>
</tbody>
Thank you so much in advance!
I am trying to find a code that will allow me to insert a new line below a selected cell, merge the cells of the new inserted line and the cell above it for column B only, and copy the equation of column C into the new row line using a button. I have the button set up and a code to insert a new line but I can't get any further. If you could help me that would be wonderful.
Example:
Insert Line below ItemA1, Merge PriceB2 and empty cell below it and copy equation from D2 to D3
A | B | C | |||||
1 | itemA1 | PriceB1 | UnitC1 | ||||
2 | itemA1 | PriceB2 | UnityC2 | ||||
NEW ROW (keep the same) | NEW ROW (merge with above) | NEW ROW (copy equation from above) | |||||
3 | ItemA3 | PriceB3 | UnitC3 |
<tbody>
</tbody>
Thank you so much in advance!