title: VBA adjust copied data
body: <p>I have two sheets in which I insert data. In sheet1 I have data in column1 and a button.</p>
  
  <p><a href="https://i.stack.imgur.com/BUE6n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BUE6n.png" alt="Sheet1"></a></p>
  
  <p>If I click the button the data will be transfered to sheet2 in row1. Afterwards the user can add captions in column1 and set "x" to the table to sort the captions to the headlines in row1.</p>
  
  <p><a href="https://i.stack.imgur.com/D9cuM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D9cuM.png" alt="Sheet2"></a></p>
  
  <p>The code for that part is not very hard and works perfectly fine.</p>
  
  <pre><code>Private Sub CommandButton1_Click()
      Zeile = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
  
      For i = 2 To Zeile
          Sheets("2").Cells(1, i) = Sheets("1").Cells(i, 1)
      Next i
  
  End Sub
  </code></pre>
  
  <p>My question is now how I can secure the entered data? If someone is entering in Sheet1 for example an G in between B and C and presses the button a second time it shall not mess up the "x" in Sheet2. 
  <a href="https://i.stack.imgur.com/9j87W.png" rel="nofollow noreferrer">Change in Sheet1</a>
  So the column of G has to stay empty but the columns of C,D,E,F shall still have their "x". (In the following picture the inserted Column is highlighted green.
  <a href="https://i.stack.imgur.com/8PHVl.png" rel="nofollow noreferrer">Change in Sheet2 after clicking the button in Sheet1</a>
  The user can enter as many rows as he/she wants in sheet1 and it shall be updated by clicking at the button. Do you have an idea how I could realize that?</p>
  
  <p>Thanks!</p>