|
Create your own macro that populates the third column with Randolph in the odd rows and your last name in the even rows. This should be coded in a loop for 10 rows. Sub oddd() For x = 1 To 10 If x = 2 Then Cells(x, 1) = "pizza" ElseIf x = 4 Then Cells(x, 1) = "pizza" ElseIf x = 6 Then Cells(x, 1) = "pizza" ElseIf x = 8 Then Cells(x, 1) = "pizza" ElseIf x = 10 Then Cells(x, 1) = "pizza" Else Cells(x, 2) = "not" End If Next x End Sub |