autofill to variable destination

I have the following code that was achieved using the macro recorder. The only problem I am running into is that during the autofill command, there are never the same amount of rows to autofill. It could be as few as 5 rows and as many as there are rows on the spreadsheet. When I recorded the macro there were 953 lines, and unfortunately I cannot figure out how to change the specific destination of 953 to a variable destination determined by when data ends.

Here is the code I currently have:

Please Login or Register  to view this content.

Thanks!

Try this:

Please Login or Register  to view this content.

Hmm. Edited, try again.