galera consegui fazer utilizando essa macro, porém ela demora ainda.. alguém pode me ajduar.. arruma ela melhorar?
Código: Selecionar todos
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AP" & X).Value
Range("AP" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
' ---------- COLUNA M
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AO" & X).Value
Range("AO" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
' ---------- COLUNA O
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AO" & X).Value
Range("AO" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
' ---------- COLUNA Q
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AO" & X).Value
Range("AO" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'-------------------------------------------------------
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AP" & X).Value
Range("AP" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("K:K").Select
If Range("K" & X).Value = "" Then
Range("K" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
' ---------- COLUNA M
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AO" & X).Value
Range("AO" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("M:M").Select
If Range("M" & X).Value = "" Then
Range("M" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
' ---------- COLUNA O
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AO" & X).Value
Range("AO" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("O:O").Select
If Range("O" & X).Value = "" Then
Range("O" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
' ---------- COLUNA Q
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AO" & X).Value
Range("AO" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AQ" & X).Value
Range("AQ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AR" & X).Value
Range("AR" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AS" & X).Value
Range("AS" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AT" & X).Value
Range("AT" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AU" & X).Value
Range("AU" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AV" & X).Value
Range("AV" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AW" & X).Value
Range("AW" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AX" & X).Value
Range("AX" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AY" & X).Value
Range("AY" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
'Coluna 11
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
Columns("Q:Q").Select
If Range("Q" & X).Value = "" Then
Range("Q" & X).Value = Range("AZ" & X).Value
Range("AZ" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.EnableEvents = True
'DELETAR EXTRAÇÃO NA COLUNA "X"
Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
Range("Y2").Select
For X = Inicio To Fim
If ActiveCell = 2 Then
ActiveCell.EntireRow.Delete Shift:=xlUp
Else
ActiveCell.Offset(1, 0).Activate
End If
Next
Range(Atual).Select
Range("B2").Select