Option Explicit
Sub Orriz_A()
Dim Ur, R, X, Y, C
Ur = Range("A" & Rows.Count).End(xlUp).Row
If Ur > 3 Then Range("I4:R" & Ur).ClearContents
For X = 4 To Ur
If Cells(X, 3) = "CELIBE" Then
Range(Cells(X, 1), Cells(X, 2)).Copy
Cells(X, 9).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = 13
If Cells(X, 4) <> 0 Then
For Y = 0 To Cells(X, 4)
Range(Cells(X, 6 + C), Cells(X, 7 + C)).Copy
Cells(X, 6 + C).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = C + 2
Next Y
End If
X = X + Cells(X, 4)
ElseIf Cells(X, 3) = "SEPARATO" Then
Range(Cells(X, 1), Cells(X, 2)).Copy
Cells(X, 9).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = 13
If Cells(X, 4) > 0 Then
For Y = 1 To Cells(X, 4)
Range(Cells(X + Y, 6), Cells(X + Y, 7)).Copy
Cells(X, C).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = C + 2
Next Y
End If
X = X + (Cells(X, 4) - 1)
ElseIf Cells(X, 3) = "CONIUGATO" Then
Range(Cells(X, 1), Cells(X, 2)).Copy
Cells(X, 9).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range(Cells(X, 6), Cells(X, 7)).Copy
Cells(X, 11).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = 13
If Cells(X, 4) > 0 Then
For Y = 1 To Cells(X, 4)
Range(Cells(X + Y, 6), Cells(X + Y, 7)).Copy
Cells(X, C).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = C + 2
Next Y
End If
X = X + Cells(X, 4)
End If
Next X
End Sub
Sub Orriz_B()
Dim Ur, R, X, Y, C
Ur = Range("A" & Rows.Count).End(xlUp).Row
If Ur > 3 Then Range("I4:R" & Ur).ClearContents
R = 4
For X = 4 To Ur
If Cells(X, 3) = "CELIBE" Then
Range(Cells(X, 1), Cells(X, 2)).Copy
Cells(R, 9).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = 13
If Cells(X, 4) <> 0 Then
For Y = 0 To Cells(X, 4)
Range(Cells(X, 6 + C), Cells(X, 7 + C)).Copy
Cells(R, 6 + C).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = C + 2
Next Y
End If
X = X + Cells(X, 4)
R = R + 1
ElseIf Cells(X, 3) = "SEPARATO" Then
Range(Cells(X, 1), Cells(X, 2)).Copy
Cells(R, 9).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = 13
If Cells(X, 4) > 0 Then
For Y = 1 To Cells(X, 4)
Range(Cells(X + Y, 6), Cells(X + Y, 7)).Copy
Cells(R, C).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = C + 2
Next Y
End If
X = X + (Cells(X, 4) - 1)
R = R + 1
ElseIf Cells(X, 3) = "CONIUGATO" Then
Range(Cells(X, 1), Cells(X, 2)).Copy
Cells(R, 9).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range(Cells(X, 6), Cells(X, 7)).Copy
Cells(R, 11).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = 13
If Cells(X, 4) > 0 Then
For Y = 1 To Cells(X, 4)
Range(Cells(X + Y, 6), Cells(X + Y, 7)).Copy
Cells(R, C).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
C = C + 2
Next Y
End If
X = X + Cells(X, 4)
R = R + 1
End If
Next X
End Sub