<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/5d40715e27994cf1962fab36b4eaacf7&quot; frameborder=&quot;0&quot; width=&quot;1280&quot; height=&quot;960&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>960</height><width>1280</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>960</thumbnail_height><thumbnail_width>1280</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/5d40715e27994cf1962fab36b4eaacf7-1678968004310.gif</thumbnail_url><duration>165.19</duration><title>Use ImportRange to extract sales data for calculating in new sheet</title><description>ImportRange helps you import data from one Google Sheet into another and keeps the two spreadsheets in sync at all times. This function can be useful when you only need a subset of the data in the main spreadsheet for your sales metrics and when you want to run calculations on your metrics, but don&apos;t want to edit the source spreadsheet.</description></oembed>