You can do this with a single line of code (it may be wordwrapped on
screen):

Range("M2:U2").Copy Range(Range("L2"), Range("L2").End(xlDown)).Offset(0,
1)

This is an example of a macro doing something programmatically rather than
in terms of how you do it manually. After you wrestle with a few of these
you'll get the hang of it.

--
Jim Rech
Excel MVP