Paula this is exactly what I was looking for. I thought I would have to use Power Pivot and set up relationships. I haven't worked through the activity yet, but I will do and I will come back to you if I have solved it. Actually, I will come back with questions if I cant solve it too. Thank you Paula and the Excel Club