I am using a macro already recorded, and the only thing I wish I could do
away with is this:
When all of the data is brought in and formatted, there are thousands of
extra empty rows that exist at the bottom of the document. I want to find a
quick way to delete those then automate it, so the macro does it for me.

OR

Is there a way to sum an entire column automatically within a macro so that
the total ends up at the bottom of the columns with values in them.
Currently with the thousands of extra empty rows, totalling the column makes
the sum appear way at the bottom of the document on line 6,000 something.
Thanks!!!