There's a lot to learn to go beyond the macro you have recorded to efficient coding. When you say that you are not a VBA programmer, does that also extend to other programming languages, or do you have experience in other programming languages.
A couple of quick reads about improving recorded macros:
This spends some time talking about getting rid of excess code in recorded macros: http://peltiertech.com/how-to-fix-a-recorded-macro/
This one goes even further: http://www.tushar-mehta.com/excel/vb...rder/index.htm
The latter link could also be interesting because he spends some time working with a copy/paste macro. He is working down columns A and AA, but the same basic idea could be used working across rows 14 and 9.
One thing I would add to Tushar Meta's macro 11 is the idea of a loop to loop across the row. If you have any prior programming experience, you have probably encountered loops before. If you are new to any kind of programming, then learning loops will be a big part of your learning. One common loop structure: https://msdn.microsoft.com/en-us/lib.../gg251601.aspx
I strongly suggest that you spend some time with those so that you understand how they work. From there I would expect something like this to do what you are describing (untested):
Bookmarks