title: Fill Excel Table with VBA Field by Field
body: <p>I have an Excel table, that I need to fill record by record.</p>
  
  <p>I began a code </p>
  
  <pre><code>Private Sub AddRecBro_Click()
      Dim Tbl As ListObject
      Dim NewRow As ListRow
  
      Set Tbl = Worksheets("Broker").ListObjects("Broker")
      Set NewRow = Tbl.ListRows.Add(AlwaysInsert:=True)
  
      ....
  
  End Sub
  </code></pre>
  
  <p>Now I would like to populate this table field by field a bit like this...</p>
  
  <pre><code>Field("ID")=Max(Broker[ID])+1
  Field("F1")=Sheets("Dashboard").Range("U5").Value
  Field("F2")=Sheets("Dashboard").Range("U6").Value
  Field("F3")=Sheets("Dashboard").Range("U7").Value
  etccc
  </code></pre>
  
  <p>I don't know how to populate my list objects this way...Actually I have my data in column and not at the same place... so i would like to select them at their location to Fill up the New record...
  Thanks</p>