I have a list of information that is neither numbered nor in alphabetical order. A second list with the same date needs to be sorted in the same way as the first list. I am unable to alter the data's order. My objective is to copy more data from the second set and paste it into the first data set.
**DATA SET A** **DATA SET B**
22350 ____ BH160 100
22355 ____ 22350 125
BH160 ____ BH190 200
BH190 ____ 22355 150
I want a new column in DATA SET A to contain the numerical value from column 2 of DATA SET B. For instance, I want 125 to appear in DATA SET 1's line 1, column 2. My list contains about 200 unique numbers and I need to update it every week.
Can someone help me? Maybe with a macro that I could use each week?