if Specific cell contains specific text then copy paste value from cell x to cell y

[Summer7sun]

I am very new to coding need help with the code," Sorry for my mistakes its my first post"
I am trying to copy data from Cell E8 to Cell AB8 if Cell T8 has Yes and if T8 has no the want to copy E8 to AC8 and want it to do the same thing for T9,T10,T11 till T108.

I have this Successfully working on only T8 Row want the same for other cells till T108. I really dont know how to go about this further Please Help. Thank You

If Range("T8") = "Yes" Then
Sheets("Engine").Select
Sheets("Engine").Name = "Engine"
Range("E8").Select
Selection.Copy
Range("AB8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("AB3").Select
Application.CutCopyMode = False
End If

If Range("T8") = "No" Then
Sheets("Engine").Select
Sheets("Engine").Name = "Engine"
Range("E8").Select
Selection.Copy
Range("AC8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("AB3").Select
Application.CutCopyMode = False
End If

 

[JackDanIce]

Not sure why, changed code and this does put the correct values into same rows for columns AB and AC respectively where column T is Yes or No only:

Sub Update_Col()
    
    Application.ScreenUpdating = False
    
    If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False
    
    With Range("E7:AC108")
        .AutoFilter
        .AutoFilter Field:=16, Criteria1:="Yes"
    End With
    Range("AB8:AB108").SpecialCells(xlCellTypeVisible).Value = Range("E9:E109").SpecialCells(xlCellTypeVisible).Value
    
    ActiveSheet.ShowAllData
    
    With Range("E7:AC108")
        .AutoFilter
        .AutoFilter Field:=16, Criteria1:="No"
    End With
    Range("AC8:AC108").SpecialCells(xlCellTypeVisible).Value = Range("E9:E109").SpecialCells(xlCellTypeVisible).Value
    
    ActiveSheet.AutoFilterMode = False
    
    Application.ScreenUpdating = True
        
End Sub

 

[Summer7sun]

JackDanIce you helped me solve the puzzle .. Awesome Thanks a lot .. what do i have to do to increase your rating ... m new to these codes and forum ... Plz add me as friend

 

[JackDanIce]

Glad it's resolved, you're welcome

 

[Summer7sun]

Hi the code really works fine till u manually type the data on T column ... I just Noted that the Data Yes or No is extracted from another worksheet when a condition is met on that sheet and the data on the other is coming from the data server which cant be edited .... so just in simple term if I manually type Yes or No on any T coumn cell the code works ... and as soon as I Paste Link I start getting error ....