Thanks Marvin, just one last thing... sorry... I don't actually have to note what the item is so I only really need to know the seller number and the amount. It would be helpful to know who the seller was but not essential as I will have that on another sheet with other details. Presumably, if I input as you have described above, I could then sort them in seller number and then autosum?