Export to Excel Macro

[jtmillington]

I have attached my current code to format the data and add variance, percentage change and explanation requirements. What I'm looking to do is also add a total formula at the bottom for columns E & F for the first sheet created. I'm just unsure of what the code is to have is skip a row at the bottom of the data and sum.

This is all in access 2010 - Thanks for your help!

 

[Trigger9008]

You may want to try:

Dim lRow as Long

lRow = Cells(Rows.Count, "A").End(xlUp).Row + 2

This will give you the cell 2 rows below the last used row.
Then you can use lRow to target your desired cell and set its '.Formula'