Match old and new table

Hi, guys I have two tables one from 2010 and one from 2021 in the 2010 table there are codes that in the 2021 table have already been transformed. I would like to know how to transform the 2010 table codes according to the 2021 table conversion.
For example: in 2010 it had the code 0123 = hypertension, in the 2021 table the code 0123 was converted to 4567 = hypertension. I would like to transform the code 0123 = 4567 in the old table. How can I do that?

I didn't see any relation either.

Originally Posted by ShinWaka

In the ex table, there was only the code 1110 (CBO - 1994), but the new table, ex1, had already been converted. The code 1110 (1994) is now 2132-05 (2002). I would like to put these converted codes in the old table.

There is no relation between the two worksheets, you want just to copy and past?

the two worksheets talk about CBO. I cant just copy and paste because there is a lot of numbers it would be too much work. What I would like to do it is transform all the codes of cbo-94 according to the codes of cbo- 2002. I don't know if you understand me.
Em uma tabela ja ha uma conversao entre cbo 94 e cbo 2002, mas em outra tabela, apenas ha o codigo do cbo 94. Eu quero converter esta tabela de acordo com o cbo -2002.
Nao consigo enviar a tabela toda, pois o arquivo é muito grande, mas se trata da Classificação Brasileira de Ocupações.

Your CBO94 numbers start with 3550 and goes up to 99930 in Pasta3.xlsx and the other file Pasta2.xlsx the same CBO94 stops at 2530 (1105 --> 2530), so how do you expect us to connect them?
I highlighted the columns for you to see the problem too.