Copy / Paste

[raybeiler1]

On the top of my sheet called Assemblies I have a table which I use for new item entry. The table is in Rows 4 - 18. I want to be able to copy this table and past it to the bottom of my sheet, repeatedly. At the end of this action I also want to then delete all rows of the pasted table where the F column is empty, and clear the contents of my original table. I hope this makes sense.

 

[raybeiler1]

I should also say, I would like to do all of this with a single macro.