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
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]itemA1[/TD]
[TD]PriceB1[/TD]
[TD]UnitC1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]itemA1[/TD]
[TD]PriceB2[/TD]
[TD]UnityC2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]NEW ROW (keep the same)[/TD]
[TD]NEW ROW (merge with above)[/TD]
[TD]NEW ROW (copy equation from above)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]ItemA3[/TD]
[TD]PriceB3[/TD]
[TD]UnitC3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]itemA1[/TD]
[TD]PriceB1[/TD]
[TD]UnitC1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]itemA1[/TD]
[TD]PriceB2[/TD]
[TD]UnityC2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]NEW ROW (keep the same)[/TD]
[TD]NEW ROW (merge with above)[/TD]
[TD]NEW ROW (copy equation from above)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]ItemA3[/TD]
[TD]PriceB3[/TD]
[TD]UnitC3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you so much in advance!