How about using a pivot table

http://www.datapigtechnologies.com/f...es/pivot1.html

VBA Noob