title: Copying row with corresponding ID number into a different worksheet
body: <p>I have a userform that lets you type in an ID number, I want the row with the corresponding ID number to be copied into a different worksheet where the cells are not aligned.</p>
  
  <p>I have tried using an array for the destination of the data but it doesn't do anything when I run it. I know I could do it the ugly way and code every single cell to go to another cell but I thought using an array for the data that is being copied would work, now I need to know how I can put all the destination cells in one varable and copy the data in there</p>
  
  <pre><code>Dim ws As Worksheet
  Set ws = Sheets("Arkiv")
  Dim DN As Worksheet
  Set DN = Sheets("DN")
  
  idRow = Sheets("Arkiv").Columns("A:A").Find(what:=IDnum).Row
  IDnum = TextBox1.Text
  
  'Dim shipFrom As Range
      'Set shipFrom = Sheets("Arkiv").Range("B" &amp; idRow)
  
  Dim goTo1 As Variant
  goTo1 = Array(DN.Range("D9"), DN.Range("E9"), DN.Range("I9"), DN.Range("C20"), DN.Range("D20"), DN.Range("E45"), DN.Range("G20"), DN.Range("H20"), DN.Range("I20"))
  
  Dim data As Variant
  data = Array(ws.Range("B" &amp; idRow), ws.Range("C" &amp; idRow), ws.Range("D" &amp; idRow), ws.Range("E" &amp; idRow), ws.Range("F" &amp; idRow), ws.Range("G" &amp; idRow), ws.Range("H" &amp; idRow), ws.Range("I" &amp; idRow))
  
  goTo1 = data
  </code></pre>
  
  <p>I expect the data from the variable "data to be copied over to the cells inside of the "goTo1" variable in the corresponding order I put them into the array with.<code>enter code here</code></p>