Help with a VBA macro ending with a LOOP

You should only need be in AV5.
And of coarse it will replicate that row, b/c your file has the same data in the following rows until the empty one. Can you not see what is happening? It copies row 5 from column AV, then row 6 , row 7. Your data is exactly the same in these rows. If you don't what the same data, you need to specufy where you what it copied. Or you need to change the data.