moactp
27-11-2013 21:31:06
Seria possível me ajudar nesta macro? Preciso localizar em uma planilha(BD) um funcionário(Seja pela matricula ou pelo nome) e colar em outras colunas da mesma linha os valores calculados em outra planilha(Calculo).
Sub Colar_BD()
'
' Colar_BD Macro
'
'
Sheets("Calculo").Select
Range("G5").Select
Selection.Copy
Sheets("BD").Select
Range("CA" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("H2").Select
Selection.Copy
Sheets("BD").Select
Range("CB" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("I2").Select
Selection.Copy
Sheets("BD").Select
Range("CC" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("K2").Select
Selection.Copy
Sheets("BD").Select
Range("CD" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("L2").Select
Selection.Copy
Sheets("BD").Select
Range("CE" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("H5").Select
Selection.Copy
Sheets("BD").Select
Range("CF" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("I5").Select
Selection.Copy
Sheets("BD").Select
Range("CG" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Sub Colar_BD()
'
' Colar_BD Macro
'
'
Sheets("Calculo").Select
Range("G5").Select
Selection.Copy
Sheets("BD").Select
Range("CA" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("H2").Select
Selection.Copy
Sheets("BD").Select
Range("CB" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("I2").Select
Selection.Copy
Sheets("BD").Select
Range("CC" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("K2").Select
Selection.Copy
Sheets("BD").Select
Range("CD" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("L2").Select
Selection.Copy
Sheets("BD").Select
Range("CE" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("H5").Select
Selection.Copy
Sheets("BD").Select
Range("CF" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Calculo").Select
Range("I5").Select
Selection.Copy
Sheets("BD").Select
Range("CG" & Rows.Count).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub