How do I Paste Value and Update when Changed

[ediejane]

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?

[TABLE="width: 1000"]
<tbody>[TR]
[TD]Collection[/TD]
[TD]Prefix[/TD]
[TD]Shape[/TD]
[TD]Size[/TD]
[TD]Supplier[/TD]
[TD]Color Code[/TD]
[TD]SKU Formula[/TD]
[TD]SKU[/TD]
[/TR]
[TR]
[TD]Rhinestone[/TD]
[TD]RHACPB[/TD]
[TD]TD[/TD]
[TD]13x18m[/TD]
[TD]NZ[/TD]
[TD]CL[/TD]
[TD]=+B3&"-"&C3&D3&"-"&E3&"-"&F3[/TD]
[TD]RHACPB-TC-13x18m-NZ-CL[/TD]
[/TR]
[TR]
[TD]Rhinestone[/TD]
[TD]RHACPB[/TD]
[TD]TD[/TD]
[TD]16m[/TD]
[TD]NZ[/TD]
[TD]CL[/TD]
[TD]=+B4&"-"&C4&D4&"-"&E4&"-"&F4[/TD]
[TD][TABLE="width: 211"]
<tbody>[TR]
[TD="class: xl66, width: 211"]RHACPB-TD16m-NZ-CLAB[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Any help is greatly appreciated.

Thank you in advance.

 

[vcoolio]

Hello EdieJane,

If your "SKU" column is Column H and your first row of data is Row2 (headings in Row1), then in cell H2 place this little formula:-

=G2

and then drag it down as far as necessary.

I hope that this helps.

Cheerio,
vcoolio.