I import a data file. There can be as few as 3 lines or as
many as several thousand. I am formatting the import to be
a report. Here is my difficulty:

I need to insert the text "TOTAL" in column H in the
second blank row beneath the last entry. I need to insert
the formula "=sum(j4:j[whatever])" in column J in the same
row. Sometimes imported records will create a multi-line
entry in a column other than H or J, resulting in blank
cells in column H and J.

How do I find the last row and put in the text and formula
I need? Any ideas or suggestions on where to look? Thanks.