Hi, between 2 spreadsheets, where column B or "Description" are the same I want to copy the adjacent cell value (Column A or "Code") from Column A in the old sheet to column A in the new sheet. The problem is that the new sheet is not all of the same data items each time so it is not a 1 for 1 sort, copy-paste job.
This is one of a few different formatted inventory sheets and the only one that has NO original "code" (yes weird and have asked source to include theirs as you would think it would be static) so I apply my own for my use each time I load it into my system. Each new sheet does not always have the same items, maybe 80% of the time. The other 20% are new and I create a new "code" which I would do manually. So since the items are not always the same I can't just sort, copy and paste. The problem with applying a new random code number each time is that if a customer places and order today and the item code is 0001, if I load a new sheet tomorrow and item 0001 has then sold out and thus 0001 gets applied to a different in-stock item that got the new 0001 designation, their fulfillment/shipping notice a few days later reads the wrong new item.
For example this is just on 2 lines of data (normally 400-600 unique items)
In sheet 1, I have:
column A column B
In the new sheet, sheet 2, I want to copy the text in the column "Code" for the same row where the Description is the same:
column A column B
This is one of a few different formatted inventory sheets and the only one that has NO original "code" (yes weird and have asked source to include theirs as you would think it would be static) so I apply my own for my use each time I load it into my system. Each new sheet does not always have the same items, maybe 80% of the time. The other 20% are new and I create a new "code" which I would do manually. So since the items are not always the same I can't just sort, copy and paste. The problem with applying a new random code number each time is that if a customer places and order today and the item code is 0001, if I load a new sheet tomorrow and item 0001 has then sold out and thus 0001 gets applied to a different in-stock item that got the new 0001 designation, their fulfillment/shipping notice a few days later reads the wrong new item.
For example this is just on 2 lines of data (normally 400-600 unique items)
In sheet 1, I have:
column A column B
Code | Description |
KS0001 | A Los Vinateros Bravos, Pipeno Blanco 2020 1L |
KS0002 | Adrien Renoir, Le Terroir Extra Brut NV |
In the new sheet, sheet 2, I want to copy the text in the column "Code" for the same row where the Description is the same:
column A column B
Code | Description |
(I need KS0002 here) | Adrien Renoir, Le Terroir Extra Brut NV |
(new random code manally generated) | Adroît, Mourvedre 2019 |