Macro for specific condition

[philky001]

HI I have an excel sheet with this data, 5 columns per date. 48's are how many visits were billed within 48 hours and after. Some cases the program creating this will have data for Tot_billed, but nothing in the 48's. This is impossible. What I want to do is run a macro that says, if the Tot_billed is not = 0, and the 48's are both 0, add to the >48 the number in the Tot_billed.


Dr Name
date visits <48 >48 Tot_billed Not Billed

 

[AFPathfinder]

Untested, but simple:

Sub SomethingAbout48s()
    Dim i As Integer
    Dim finalRow As Integer
    
    finalRow = Cells(Rows.Count, 1).End(xlUp).Row
    
    For i = 2 To finalRow
        If Cells(i, 2).Value = 0 And Cells(i, 3).Value = 0 And Cells(i, 4).Value > 0 Then
            Cells(i, 3).Value = Cells(i, 3).Value + Cells(i, 4).Value
        End If
    Next i
End Sub