Código: Selecionar todos
Private Sub btngerar_Click()
Dim Vara As String, Acao As String, Status As String
Vara = "*": Acao = "*": Status = "*"
Plan4.Range("B4:L5000").ClearContents
lin = 2
linha = 4
If Combovara <> "" Then Vara = Combovara.Value
If Comboacao <> "" Then Acao = Comboacao.Value
If Combostatus <> "" Then Status = Combostatus.Value
'filtro por datas
If cdDataINI = "" Or cdDataFIM = "" Then Exit Sub
Do Until Plan3.Cells(lin, 2) = ""
If Plan3.Cells(lin, 5) >= CDate(cdDataINI) And _
Plan3.Cells(lin, 5) <= CDate(cdDataFIM) And _
Plan3.Cells(lin, 3) Like Vara And Plan3.Cells(lin, 4) Like Acao And Plan3.Cells(lin, 7) Like Status Then
Plan4.Cells(linha, 2) = Plan3.Cells(lin, 1) ' cliente
Plan4.Cells(linha, 3) = Plan3.Cells(lin, 3) ' vara
Plan4.Cells(linha, 4) = Plan3.Cells(lin, 4) ' ação
Plan4.Cells(linha, 5) = CDate(Plan3.Cells(lin, 5)) ' data de ajuizamento
Plan4.Cells(linha, 6) = Plan3.Cells(lin, 7) ' status
Plan4.Cells(linha, 7) = Plan3.Cells(lin, 6) ' valor da inicial
Plan4.Cells(linha, 8) = Plan3.Cells(lin, 8) ' valor recebido
Plan4.Cells(linha, 9) = Plan3.Cells(lin, 9) ' honorário
Plan4.Cells(linha, 10) = Plan3.Cells(lin, 10) '70%
Plan4.Cells(linha, 11) = Plan3.Cells(lin, 11) '15%
Plan4.Cells(linha, 12) = Plan3.Cells(lin, 12) 'paulo
linha = linha + 1
End If
lin = lin + 1
Loop
Do Until Plan3.Cells(lin, 1) = ""
If Plan3.Cells(lin, 3) Like "*" & UCase(Combovara) & "*" And _
Plan3.Cells(lin, 4) Like "*" & UCase(Comboacao) & "*" And _
Plan3.Cells(lin, 7) Like "*" & UCase(Combostatus) & "*" Then
Plan4.Cells(linha, 2) = Plan3.Cells(lin, 1) ' cliente
Plan4.Cells(linha, 3) = Plan3.Cells(lin, 3) ' vara
Plan4.Cells(linha, 4) = Plan3.Cells(lin, 4) ' ação
Plan4.Cells(linha, 5) = CDate(Plan3.Cells(lin, 5)) ' data de ajuizamento
Plan4.Cells(linha, 6) = Plan3.Cells(lin, 7) ' status
Plan4.Cells(linha, 7) = Plan3.Cells(lin, 6) ' valor da inicial
Plan4.Cells(linha, 8) = Plan3.Cells(lin, 8) ' valor recebido
Plan4.Cells(linha, 9) = Plan3.Cells(lin, 9) ' honorário
Plan4.Cells(linha, 10) = Plan3.Cells(lin, 10) '70%
Plan4.Cells(linha, 11) = Plan3.Cells(lin, 11) '15%
Plan4.Cells(linha, 12) = Plan3.Cells(lin, 12) 'paulo
linha = linha + 1
End If
lin = lin + 1
Loop
Range("H4").Select
If ActiveCell.Value = "" Then
Exit Sub
End If
Range("H3").End(xlDown).Offset(1, 0).Select
ActiveCell = WorksheetFunction.Sum(Columns("H:H"))
Range("I4").Select
If ActiveCell.Value = "" Then
Exit Sub
End If
Range("I3").End(xlDown).Offset(1, 0).Select
ActiveCell = WorksheetFunction.Sum(Columns("I:I"))
Range("I4").Select
If ActiveCell.Value = "" Then
Exit Sub
End If
Range("J3").End(xlDown).Offset(1, 0).Select
ActiveCell = WorksheetFunction.Sum(Columns("J:J"))
Range("K3").Select
If ActiveCell.Value = "" Then
Exit Sub
End If
Range("K3").End(xlDown).Offset(1, 0).Select
ActiveCell = WorksheetFunction.Sum(Columns("K:K"))
Range("L4").Select
If ActiveCell.Value = "" Then
Exit Sub
End If
Range("L3").End(xlDown).Offset(1, 0).Select
ActiveCell = WorksheetFunction.Sum(Columns("L:L"))
MsgBox "Processo concluído - " & cdDataINI & " à " & cdDataFIM
'Unload Me
End Sub