title: Any Suggestion to speed-up this code or make it more efficient (VBA Excel)?
body: <p>I was wondering if there is a more efficient way to write the below code in order to make it faster.</p>
  <p>I have main board that needs to be filled up with many values coming from MyData sheet:</p>
  <pre><code>Sub MyMainBoardPopulate()
  Dim destinationWs As Worksheet
  Dim destinationLastRow As Long, x As Long, LCol As Long, ColLetter As String, MyHeader As Range
  Set destinationWs = ThisWorkbook.Worksheets(&quot;Main Board&quot;)
  destinationLastRow = destinationWs.Range(&quot;A&quot; &amp; Rows.Count).End(xlUp).Row
  For x = 2 To destinationLastRow
  On Error Resume Next
  RetVal = destinationWs.Evaluate(&quot;INDEX(‘MyData’!$E:$E,MATCH(1,($A&quot; &amp; x &amp; &quot;=‘MyData’!$B:$B)*(&quot;&quot;A&quot;&quot;=‘MyData’!$D:$D),0))&quot;)
  destinationWs.Range(&quot;C&quot; &amp; x).Value = RetVal
  On Error GoTo 0
  Next x
  For x = 2 To destinationLastRow
  On Error Resume Next
  
  RetVal2 = destinationWs.Evaluate(&quot;INDEX(‘MyData’!$E:$E,MATCH(1,($A&quot; &amp; x &amp; &quot;=‘MyData’!$B:$B)*(&quot;&quot;B&quot;&quot;=‘MyData’!$D:$D),0))&quot;)
  destinationWs.Range(&quot;D&quot; &amp; x).Value = RetVal2
  
  
  On Error GoTo 0
  Next x
  For x = 2 To destinationLastRow
  On Error Resume Next
  
  RetVal3 = destinationWs.Evaluate(&quot;INDEX(‘MyData’!$E:$E,MATCH(1,($A&quot; &amp; x &amp; &quot;=‘MyData’!$B:$B)*(&quot;&quot;C&quot;&quot;=‘MyData’!$D:$D),0))&quot;)
  destinationWs.Range(&quot;E&quot; &amp; x).Value = RetVal3
  
  
  On Error GoTo 0
  Next x
  For x = 2 To destinationLastRow
  On Error Resume Next
  
  RetVal4 = destinationWs.Evaluate(&quot;INDEX(‘MyData’!$E:$E,MATCH(1,($A&quot; &amp; x &amp; &quot;=‘MyData’!$B:$B)*(&quot;&quot;D&quot;&quot;=‘MyData’!$D:$D),0))&quot;)
  destinationWs.Range(&quot;F&quot; &amp; x).Value = RetVal4
  
  
  On Error GoTo 0
  Next x
  
  
  
  End Sub
  </code></pre>
  <p>I had to remove some formulas because otherwise the system would not allow me to post but I have 8 index match operations in this code.
  Thank you</p>