Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
but not an expert and would struggle to complete
For I = 2 To lastRow
Select Case Cells(I, "G").Value
Case [red]"IRS"[/red]
Select Case Cells(I, "J").Value
Case [red]"BUY"[/red]
Cells(I, "T").Value = [red]"Client"[/red]
Cells(I, "U").Value = [red]"Dealer"[/red]
Case [red]"SELL"[/red]
Cells(I, "T").Value = [red]"Dealer"[/red]
Cells(I, "U").Value = [red]"Client"[/red]
End Select
Case Else
Select Case Cells(I, "J").Value
Case [red]"BUY"[/red]
Cells(I, "T").Value = [red]"Dealer"[/red]
Cells(I, "U").Value = [red]"Client"[/red]
Case [red]"SELL"[/red]
Cells(I, "T").Value = [red]"Client"[/red]
Cells(I, "U").Value = [red]"Dealer"[/red]
End Select
End Select
Next I
combo said:The flow in the big [tt]If ... End[/tt] If block is terminated when the first condition is satisfied. You process V, W, X and Y columns, in a specific order, is it intended to skip other tests after first True?