Adapt A Piece of Summing Code

[timbo1957]

Hi,

My objective is to have two columns of figures AJ & AK with totals at the bottom.

I have this piece of code which I run to total Column AK -

Please Login or Register  to view this content.

It works out where the last cell with data in is and then sums the column in the cell beneath the last cell with figures in it, the data currently ends at AK14373 and there is a sum in AK14374.

When it has done this calculation I want to move one cell to the left to AJ14374 and sum AJ14373 Upwards to AJ2.

I can't use the same formula because the data in column AJ ends at AJ13470 and it puts the formula in AJ13471.

The ranges change each month.

Thanks for any help.

[alvin-chung]

How about adding this to your existing code?

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin