Untitled
unknown
plain_text
2 years ago
357 B
6
Indexable
Sub SummarizeColumns() Dim lastRow As Long lastRow = ActiveSheet.Cells(Rows.Count, "Q").End(xlUp).Row For i = 4 To lastRow If Cells(i, "Q").Value = "VO" Then Cells(i, "G").Value = Cells(i, "Q").Value + Cells(i, "S").Value Else Cells(i, "G").Value = Cells(i, "S").Value End If Next i End Sub
Editor is loading...