E
elsg
Hello
I Have various data in column "E", and would like to put the result i
each cell of column "F"
Sub teste()
Dim vResultado
Dim LR As Long
LR = Range("E" & Rows.Count).End(xlDown).Row
vResultado = Application.SumIf(Range("A2:A3000"), Range("E3")
Range("B2:B3000"))
Cells(LR + 1) = vResultado
End Sub
does anyone know how to do?
Thank you
I Have various data in column "E", and would like to put the result i
each cell of column "F"
Sub teste()
Dim vResultado
Dim LR As Long
LR = Range("E" & Rows.Count).End(xlDown).Row
vResultado = Application.SumIf(Range("A2:A3000"), Range("E3")
Range("B2:B3000"))
Cells(LR + 1) = vResultado
End Sub
does anyone know how to do?
Thank you