Sum after last row once data is pasted

Originally Posted by ~TaC~

This works but I need to run the macro each time for it to show total?

@Richard Buttrey

The idea of asking for help is because I don't know how to do it, I know how to do a bog standard sum but how would it know to display in the cell after the last row?

Does it really need to be in the cell underneath the last item?
Surely the days of totals at the bottom of a list went out of fashion after we ditched pencil and paper and went digital.

The best place for totals is in a fixed cell above the data. If it needs to be visible all the time then either set a freeze pane underneath the total, or an often forgotten - (or never known way) is to use the camera tool and take a shot of the total cell then move the camera image to wherever you want.