What I am looking for is a VBA code or Macro that will do the following. As I am typing in values in one sheet tab another sheet tab is looking at those values. What the code is looking for is the duplicate material types so it can sum the quantities of those materials and then delete all but one line with the quantities totaled on that one line. Any help in this would be very appreciated. I have been working on this and have come close using a button. The problem I run into is that it sometimes will not delete all the duplicate values. If I use the same data every time it randomly leaves values and most times never the same values. Again any help would be appreciated.