Excel vba code to add row based on column values and sum values to the newly added row

[Ganeshan]

The following are the conditions that I am trying to achieve

1. Sort Column F and H, then add a row when there is a value change in both rows. The condition must add a row when the values change

• Sell - D
• Sell - S
• Buy - D
• Buy - S

1. After creating the blank row the Column I must sum the values by looping and the summed value must populate in the newly inserted row
2. Copy the summed value to another worksheet into a particular cell, the code must work with any number of data.