Thanks, this seems to be exactly what im looking for. I've heard of pivot tables before but never thought i would have any use for them. They seem a bit complicated, but i'm sure i'll figure it out perhaps with a little help from you guys.