As the total column move day by day, for example today if its in Column P
tomarrow it may move to column E or A etc...

so my macro code should sum the column based on active cell

"Ranjit kurian" wrote:

I have a column called as TOTAL and this column contain numbers, and the
number keep increasing or decreasing , so i need a macro so that it always
sum the total column(last row)

TOTAL
1
2
3
6 - sum