Adding a last row in a range adding the previous!

[apla]

Hi there.

I use this code for getting back in another sheet results according the dates distance and a a customer code.

What i need is when i get my results using the code, after the last used row to appear a word "Total" in column A and the sum of previous cells in column C.

Please Login or Register  to view this content.

Any help on this is much appreciated.

Thanks in advance.

[AB33]

Try the attached. I made a separate code.

[apla]

Your code works like a charm!

Thank you.

I don't know if i must start a new thread for this or not but i'd like to ask for you if you know how to modify the code that i use to don't transfer the Headers from data sheet to macro sheet?

[AB33]

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

[apla]

It's works great.

Thank you so much!