Paste a formula in a column in each in each row that contains data

I am copy/pasting data from a report on a webpage into excel. The number of rows varies each time. I am performing functions on this data to make it suit my needs a little better. Lets assume that there are 800 rows of data this time and columns A thru F contain data. In column G, I insert a function =RIGHT(D1,5).
Now I want to copy this function down to row 800. However, next time there might be 1015 rows that I would need it to copy to. How can I have it copy/paste to the last row on the worksheet?

Thanks...worked perfect.

Please Login or Register  to view this content.