How to copy and paste into multiple rows within SAME column

Hi there,

I'm working on a macro that will copy a row of info and then paste it into the next 7 rows, then when new information is entered into the last free row that row will also be copied and pasted into the subsequent rows. So I want to create a process where if you were to click and drag the information on an excel sheet, it would create an autofill effect. So for instance, "A1:D1" has the information, but I want the information in there to be copied and pasted until "A8:D8". Then another row of data is entered into "A9:D9" and it will be copied and pasted until "A17:D17". The number of rows it will be pasted to won't change.

Is there any coding I could use to help me?

I've already looked at the following thread:
http://www.excelforum.com/excel-gene...tomate-it.html

However, it was looking at pasting into other columns.

I'd appreciate any help I can get - thanks!

if you're going to copy and paste multiple rows and have them copied multiple times, it would be much more efficient to do the entry then have the macro run it on all the entries at the same time with a simple loop, let me know if that works for you or if there is a specific reason that you want to do it line by line