Hello,
I am not good at using vba, and I need help with a task if this is not too much trouble.
This is my situation. I have two sheets, each with two columns, sheet 1 contains a code (column A) that corresponds to a task in Spanish (column B). Sheet 2 contains the code (column A) and the task in English (column B). The two sheets have the same list of tasks (one in English and one in Spanish), but the lists are not in the same order, they are scrambled, and the lists are lengthy.
I would like to find out if there is a simple code to do the following: switch the task in English (column B) in sheet 2, with the task in Spanish that corresponds to the same code as in sheet 1. In other words, find the value of 'sheet 2'!A4 in sheet 1, and copy its adjacent cell value (which should contain the text in Spanish) into sheet 2 B4. This, for every value in column A of sheet 2.
Thank you very much in advance, I have lost some hair trying to do this.
Sincerely,
Manuel
I am not good at using vba, and I need help with a task if this is not too much trouble.
This is my situation. I have two sheets, each with two columns, sheet 1 contains a code (column A) that corresponds to a task in Spanish (column B). Sheet 2 contains the code (column A) and the task in English (column B). The two sheets have the same list of tasks (one in English and one in Spanish), but the lists are not in the same order, they are scrambled, and the lists are lengthy.
I would like to find out if there is a simple code to do the following: switch the task in English (column B) in sheet 2, with the task in Spanish that corresponds to the same code as in sheet 1. In other words, find the value of 'sheet 2'!A4 in sheet 1, and copy its adjacent cell value (which should contain the text in Spanish) into sheet 2 B4. This, for every value in column A of sheet 2.
Thank you very much in advance, I have lost some hair trying to do this.
Sincerely,
Manuel
