Is there a way that when the value in a cell changes that I can input a row
over the changed value and subtotal the previous information? If the value
in cell 1 was 020 and continued until cell 5. A new value is entered in cell
6 030. I want the row to be inserted over the 030 and subtotal the
informtaion for 020.