macro - autofill formula to end of data rows

Good afternoon,

Is there a way of having the formula that is being entered in to H9 be copied down the rows until the end of the data? The spreadsheet that is generated for me is not always going to have the same number of rows. I have looked at the post http://www.excelforum.com/showthread.php?t=624654 but am unsure how to incorporate it in to my code.......

Please Login or Register  to view this content.

Also, I am just wondering if there is a way to add the records under the script and target headings as 'next record' or something similar.

Please Login or Register  to view this content.

This will mean that as new scripts get added or deleted, there are no blank spaces in this list and will make it easier to maintain on an ongoing basis.

Any help would be much appreciated.

Full copy of my macro is as follows:

Please Login or Register  to view this content.