Based on what you've said about how they use Excel, that's probably a sure indication that there's a better way. IMHO, pivots are your best bet and incredibly simple to set up and use. If you want to email me your original file, I can look at it and see if we can work something up. I promise full confidentiality.