I've fairly large worksheets, around 20 to 25k rows each. 20 in total.

Some of the data contained within is as follows:

Req ID Source Interview Hired
1234 website 2 0
1234 commercial 10 2
1234 website 1 1
1234 magazine 3 0

I need to keep the data as a basic list as it is now (no combining figures
via pivot or anything), but I'd like to find a way to automate the combining
of data for redundant sources. In the example data, "website" source is
listed twice with different figures. I need a way to consolidate it to one
row, summing the figures in Interview and Hired.

Any ideas would be greatly appreciated.

Thanks in advance,
Brad