This doesn't always give me the last row.

Also it does not number  each row  in the "last column"
after the data. I need it to place a number going down
the page against each row which has data  in the last
column.

The data has column  headings for each of the 26+
columns and each row begins with a client name.