I want to have what value is entered in column E which is Yes, No, or Blank to dictate what is in column F to list Yes = HI, No = N/A, Blank = Blank.
I figured out how to do if for a single cell but how do you apply it for the entire column E and R?
Sub Network()
If Range("E3").Value = "No"...