Is there a way that i can make excel 97 or 2000 give me a subtotal for each page columns as a footer and then give me a final grand total at the end of the last page. I know this is possible with VBA but iam not good at that. any help out there will be appreciated