From input of this kind:
CUSTOMERCODE DATE QTY
890550 16/04/2013 10
890550 16/04/2013 20
890550 17/04/2013 20
890551 18/04/2013 30
890551 18/04/2013 30
890551 18/04/2013 30
how may I achieve the following result with a macro?:
CUSTOMERCODE DATE QTY
890550 16/04/2013 30
890550 17/04/2013 20
890551 18/04/2013 90