Here's the situation:

I have a workseet that contains data on defective parts. The pertinent
columns are item# (Col C), defect code (Col D), and number of defective parts
(Col E).
I would like to be able to copy/paste this data from an external source
(some crappy locally-created database).
After pasting the data, I would like to have the list automatically filtered
for unique defect codes, put that list onto another sheet where I can then do
a SUMIF for each defect code and come up with a Top 10 list.
Then the same thing for unique part#'s.

So, is there a way to automate the unique records filter?