Private Sub CommandButton1_Click()
Dim Y%
For Y = 6 To 36
If Application.CountA(Range(Cells(4, Y), Cells(30, Y))) = 0 Then
Range(Cells(4, Y), Cells(30, Y)).value=Range("C4:C30").value: Exit Sub
End If
Next Y
End Sub
Private Sub CommandButton1_Click()
C = Cells(4, 36).End(1).Column + 1
If C < 6 Then C = 6
Range("C4:C30").Copy
Cells(4, C).PasteSpecial xlPasteValues
End Sub