for excel to automatically add in a line if customer places bigger order

i dont know if this can be achieved via excel, is ther a way to automatically add a line if a customer wants to place a bigger order? for example in the attachment in row 12, to automatically enter new line and subtotlas to automatically scroll down and add it in the line? please help or point me in the direction on what i should be searching for. thanks.