Bom dia, @gean277

Sub AtualizaFérias()
  Dim rgTrader As Range, rgCF As Range, rgSaldo As Range
  Set rgSaldo = Worksheets("Saldo").[C11:V11]
  Set rgTrader = Worksheets("Controle_de_Ferias").ListObjects("Tabela1").ListColumns("Trader").Range
  Set rgCF = rgTrader.Find(What:=rgSaldo.Offset(, -1).Value, After:=rgTrader.Cells(1), _
                           LookIn:=xlValues, LookAt:=xlWhole)
  If Not rgCF Is Nothing Then
    rgCF.Offset(0, 2).Resize(, 20).Value = rgSaldo.Value
  End If
End Sub
 

@edsonbr Muito obrigado! Ajudou bastante.