display the total at the bottom of the sheet in right format

[aman1234]

Hi guys

Please see the code below. I want to display the total number of visible records after autofilter and total amount at the bottom of the printed sheet. If I don't use j=j+1 then at first attempt it overlaps the last used row in excelsheet with the total and if I use it then everytime we press the button the total will appear 1 row down. But I always want to display the total after suppose 2 rows of the filtered data so that it will show us exactly this is the data and after that this is the total.

Please Login or Register  to view this content.

I hope you understand my problem.

Thanks

[aman1234]

Hi folks

Can anyone please help me to solve my problem????

Thanks