Macro question: copying different value x number of times [Closed]

Report
-
Hello,

I am trying to paste a different value [which I copy from cells(1,i)] every 9 rows down column A. For example, will copy value B1 and paste it from Range (A1:A19) then copy C1 and paste in the following 9 rows (A20:A28).

Is there a way to do this faster?

Thanks!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!