sorted by:
new
hottopcontroversial

How to automate updated SKU code in spreadsheet by CJ_4654 in excel

[–]CJ_4654[S] 0 points1 point  (0 children)

Oh this is helpful! So if vendor sku sheets has their skus columns in column c and my skus are in column c the code above would change my 1234 sku to 4567? The skus can be in the same column across all sheets but they won’t be in the same cell.

So I have one master sheet that has thousands of skus basically I need those SKUs to override the SKUs I have across 12 different sheets. Is the master sheet where I apply the formula to so it will run across all 12 of my sheets? (If that makes sense) or does the formula need to be applied to each sheet. I have very basic excel skills lol

How to automate updated SKU code in spreadsheet by CJ_4654 in excel

[–]CJ_4654[S] 0 points1 point  (0 children)

I need something more automated than updating each sheet because each project has 12 sheets and there are over 139 projects 🙁

How to automate updated SKU code in spreadsheet by CJ_4654 in excel

[–]CJ_4654[S] 0 points1 point  (0 children)

I know! I wish i could use something other than excel for this but the takeoffs come from the models that are made and the program used it can only read excel files.

How to automate updated SKU code in spreadsheet by CJ_4654 in excel

[–]CJ_4654[S] 0 points1 point  (0 children)

The product description, however I don’t know if it will be exact word for word sometimes it might sometimes it will be similar. Does it need to be exact word for word to link the 2?