Cells in "SKU" column are the pasted value of cells in "SKU Formula" (concatenate) column.
How do I get the "SKU" column (pasted value) to automatically update when a change is made to data in cells shown in SKU formula?
<tbody>
</tbody>
Any help is greatly appreciated.
Thank you in advance.
How do I get the "SKU" column (pasted value) to automatically update when a change is made to data in cells shown in SKU formula?
Collection | Prefix | Shape | Size | Supplier | Color Code | SKU Formula | SKU | |
Rhinestone | RHACPB | TD | 13x18m | NZ | CL | =+B3&"-"&C3&D3&"-"&E3&"-"&F3 | RHACPB-TC-13x18m-NZ-CL | |
Rhinestone | RHACPB | TD | 16m | NZ | CL | =+B4&"-"&C4&D4&"-"&E4&"-"&F4 |
<tbody> </tbody> |
<tbody>
</tbody>
Any help is greatly appreciated.
Thank you in advance.