Hi,

I am trying to write a code that copies an active cell 12 columns out, without specifying the 12th column.

Capture.PNG

The highlighted rows are an example of what I am looking for.
I was thinking of doing something like:

For Each cell in Range("M:Z")
**somehow auto-fill each cell containing a value in the range to 12 cells to the right.

Anything is helpful thank you!