title: TFS 2013 - Link Work Items via Spreadsheet
body: <p>I have an Excel worksheet with hundreds of TFS 2013 Work Item IDs populating both Column A and Column B. For illustrative purposes, let's just say I have the following:</p>
  
  <p>Row 1 to Row 100 of Column A: Populated with the Work Item IDs of 100 Bug Work Items</p>
  
  <p>Row 1 - Row 100 of Column B populated with the Work Item IDs of 100 Task Work Items.</p>
  
  <p>What I'd like to do is have an automated process, e.g. a script that iterates through the hundred rows of my Excel spreadsheet and link the work item IDs in Column A with the corresponding work item IDs in Column B on the same row, e.g. link the work items listed in A1 to that of B1, A2 to B2, A3 to B3, etc. </p>
  
  <p>I can for instance see a For loop achieving such a requirement.</p>