title: Google Sheet: How to use arrayformula to copy data from one sheet to another?
body: <p>In a Google spreadsheet, I want to sync A2:G500 in sheet1 to sheet2, I've been aware of the following two methods:</p>
  <ol>
  <li><p>use <code>IMPORTRANGE</code>: put the following formula in A1 of sheet2:</p>
  <p>=IMPORTRANGE(&quot;<em>spreadsheet_url</em>&quot;,sheet1!A2:G500)</p>
  </li>
  </ol>
  <p>It works but it feels like I am overdoing it, besides there seem to be a performance issue</p>
  <ol start="2">
  <li>In A2 of sheet2, put formula <code>=sheet1!A2</code>, then drag the formula to G500 in sheet2. This one is intuitive and simple to do. However, it doesn't work if sheet1 is a form response sheet - when new response is added, sheet2 won't automatically get it.</li>
  </ol>
  <p>For learning purpose, I'm wondering if there is a way to do this using <code>Arrayformula</code>. Besides, I want to find a way to make this sync more care-free, meaning if there are indefinite rows of data I won't have to go back to this sheet every now and then and change the formula or manually drag the formula. Is this possible? And is <code>Arrayformula</code> the right way to go for this purpose?</p>