Macro para ARRUMAR

Prime

19-03-2014 04:26:48

Boa noite!

Se "NA COLUNA (J), Qualquer célula for = a [NADA] "a macro deve pegar o dado da linha da frente que vai estar na coluna (K) e colar na coluna (J) e deletar a informação da coluna (K) para que não tenha contatos duplicados" . PRECISO REPETIR esse processo 20 MIL VEZES descendo para as linhas de baixo, então a macro deve verificar linha por linha.. não estou conseguindo me ajudem por favor!

SEGUE EXEMPLO DO PLANEJAMENTO "INICIO"<---------

COLUNA J || COLUNA K || COLUNA L || COLUNA M || COLUNA N || COLUNA O
................ dado1256...............
...........................................
dados653
.....................dado598..................das4daw ... dadoe54
dado984
..........................................

SEGUE EXEMPLO DO PLANEJAMENTO ****COMO DEVE FICAR****

COLUNA J || COLUNA K || COLUNA L || COLUNA M || COLUNA N || COLUNA
dado1256 dado2565 <----------------------
dado549
dados653
dado598 dado789 dadoe54
dado984
dado879

TODOS OS DADOS FORAM PARA FRENTE ME AJUDEM POR FAVOR!!
OBS: As informações devem se concentra na coluna (J) depois (K) etc..
Eles estão espalhados devem juntar

TENTEI USAR ESSA MACRO MAIS TENHO QUE FICAR REPETINDO ELA E TBM ELA NÃO ARRUMA TUDO..

Atual = ActiveCell.Address
Inicio = ActiveCell.Row
Fim = ActiveSheet.Cells(ActiveSheet.Rows.Count, "E").End(xlUp).Row
For X = Inicio To Fim
If Range("J" & X).Value = "" Then
Range("J" & X).Value = Range("K" & X).Value
Range("K" & X).Value = ""
Else
ActiveCell.Offset(1, 0).Activate
End If
Next


SEGUE ARQUIVO EM ANEXO

Prime

21-03-2014 15:11:27

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

webmaster

22-03-2014 00:25:43

Prime,

Mais ordem por favor. Se GRITAR novamente, vou baní-lo.

Abraços