Autosum macro for Excel

[china99boy]

Hi all,

I have a query that is exported to an excel template. Everytime my data is exported to excel I may get more or less rows of information. What I am trying to do is create a macro or any way that would automate the process of placing the total for each column at the bottom. I could use the autosum function but the amount of rows are always changing. Once the data is imported into excel, I want excel to move to the last row and insert the sum for each row. Please help me with the best way to accomplish this task.

 

[HaHoBe]

Hm, china99boy,

double post - and as far as I know Users can´t delete their own posts if the Admin hasn´t given them that option. Let´s continue in http://www.access-programmers.co.uk/forums/showthread.php?t=106969...

Ciao,
Holger