I have "Product Code" in column A and Quantity in column B. The product codes in col A are not in order. What I am going to do is to add up the quantities of same items. In fact I have written an VBA to do that but I found that it takes quite a lot of time to run (more than half an hour). I would like to know if there is any faster VBA. Thanks