Sounds like a job for "Pivot Table Man"

email me the work book with some sample data and a brief description of whta you are looking to achieve.