Sub ex()
Dim xR As Range, x%
For Each xR In Range("A1:A108") '½d³ò¦Û¦æקï
If xR = "code" Then
For x = 8 To Range("AUW1").Column Step 7 '³Ì«á½Æ»s¦ì¸m¦Û¦æקï
xR(2, x).Resize(1, 6) = xR(2, 1).Resize(1, 6).Value 'code¦r¤U²Ä2¦C
xR(5, x).Resize(1, 6) = xR(5, 1).Resize(1, 6).Value 'code¦r¤U²Ä5¦C
Next
End If
Next
End Sub