title: Is it possible to make Google Sheets import range static after importing?
body: <p>So I want to copy data from another Sheet (n=3000+) and able to modify, write and delete it. But Sheet will always override from the original imported data, so whatever I tried to overwrite or delete will be restored back to the original form. So is there a way to keep all the imported data static?</p>
  
  <pre><code>=IMPORTRANGE("KEYA","SHEET1!A2:A")
  </code></pre>
  
  <p>So if sheet A is the data being imported, sheet B should be able to freely modified without changing back to sheet A's data.</p>