Can I use a code that will look in column E, find all of one item number (example 100012) and then add all the totals of that item that is in column C, and put that total on the next sheet in,a cell I choose? I will have 8 or 10 item numbers, I could duplicate this code and change the area it's looking in correct? Thank you, let me know if this could be done. Thanks for your help.