Pl run this "FilBlank" macro on the worksheet.
Your views are welcome.
Sub FilBlank()
Dim unifstro, unilstro, Lro, TA, TB As Long
unifstro = Range("C:C").Find("UNIVERSAL").Row
unilstro = Range("C" & unifstro).End(xlDown).Offset(-1, 0).Row
Lro = Sheets("Sheet1").Range("D3").End(xlDown).Row
For TA = unifstro To unilstro
If Range("E" & TA) = "TEX105" And Range("G" & TA) = "SSP" Then Range("H" & TA) = "20/4"
Next TA
For TB = 3 To Lro
If TB = unifstro Then TB = unilstro + 1
If Range("E" & TB) = "TEX105" And Range("G" & TB) = "SSP" Then Range("H" & TB) = "'12/2"
Next TB
End Sub
Bookmarks