Turn your template into an Excel Table using the Ctrl + T keyboard shortcut. These have calculated columns that autofill formulas, and the tables themselves auto expand to accommodate new data.
0
solved How can I create a template that will auto populate/calculate cells based on a SKU value? [closed]