Copy Adjacent Cell if Cells Match in 2 Separate Worksheets

Status
Not open for further replies.

tkoby11

New Member
Joined
Dec 18, 2021
Messages
23
Office Version
  1. 2021
Platform
  1. MacOS
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
CodeDescription
KS0001A Los Vinateros Bravos, Pipeno Blanco 2020 1L
KS0002Adrien 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
CodeDescription
(I need KS0002 here)Adrien Renoir, Le Terroir Extra Brut NV
(new random code manally generated)Adroît, Mourvedre 2019
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Status
Not open for further replies.

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top