title: importrange formula and auto update?
body: <p>I use importrange for combine 2 google sheet Target A and Source B</p>
  <p>In sheet A =</p>
  <pre><code>Importrange(“linkgooglesheetB”,”SheetB!!A2:M1000)
  </code></pre>
  <p>It’s done
  But when data in sheet Source B cleared/changed, then
  Data in sheet Target A cleared/changed too</p>
  <p>What formula can use same my above formula but data in Target A do not change  after combined (A&amp;B), when B changed.</p>