Subtotal method adds the grand total way further down on the sheet

Hello

I have a spreadsheet and I need to repeat subtotaling the rows( around 2000); everytime I do it, through macro, the Grand total is added way furhter down on the sheet; what can I do?

Thanks!