title: Make rows sort together in excel without having value
body: <p>I have an excel workbook with 2 sheets. </p>
  
  <p>Column A of Sheet 1 and 2 are the exact same data. When I sort the first sheets data, Sheet 2 Column A is automatically sorted because it is referenced. (='Sheet1'!$A$2:$A$100).</p>
  
  <p>But when I sort the above, Column B's cells in Sheet 2 don't follow the row of data. Now the data gets messed up because B2 in Sheet 2 did not move with the original A2 data that is referencing the first sheet.  </p>
  
  <p>Is there a way to keep the data together?</p>
  
  <p>Below are images of sample data: </p>
  
  <p>Sheet 1
  <a href="https://i.stack.imgur.com/79cq6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/79cq6.png" alt="Sheet 1"></a>
  Sheet 2
  <a href="https://i.stack.imgur.com/xb9z8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xb9z8.png" alt="Sheet 2"></a></p>
  
  <p>Now when I sort sheet 1 from Z-A: 
  Sheet 1 Sorted:
  <a href="https://i.stack.imgur.com/Nrlrf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Nrlrf.png" alt="Sheet 1 Z-A"></a>
  Sheet 2's sorted data (Not matching) 
  <a href="https://i.stack.imgur.com/GYGZ0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GYGZ0.png" alt="Sheet 2 Z-A"></a></p>
  
  <p>I want the phone number and contact name in sheet 2 to follow Alafia Village. Is there a way to make that happen? </p>