title: Get Value from another file
body: <p>I want to get <strong>Values</strong> from another workbook based on <strong>No.Id</strong> and insert a new column between columns.</p>
  
  <p>For example, I have data like this:<br>
  1st workbook is on the left and 2nd Workbook on the right is.<br>
  <a href="https://i.stack.imgur.com/syUcp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/syUcp.png" alt="enter image description here"></a></p>
  
  <p>On 2nd Workbook I want to insert a new column between column and put the values based on <strong>No.Id</strong> after click on <strong>CommandButton1</strong>.</p>
  
  <p>So the 2nd Workbook looks like this after macro<br>
  <a href="https://i.stack.imgur.com/27tlm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/27tlm.png" alt="enter image description here"></a></p>