Need to write a VBA script to go in an excel spreadsheet to find a string, then replace it with an underlined version of that string. Instructions are within the example excel sheet provided.
Hola he visto tu archivo de excel y puedo hacer el trabajo, me gustaría conversar por chat si hay algún otro detalle para tener bien claro el resultado que deseas. Estaré por aca si gustas charlar.
Saludos
Edgar
Hello
Firstly, please confirm that my understanding is correct
The translation pertaining to the selected item from the dropdown is supposed to be retrieved from the "List of translations" sheet and should be updated accordingly in the next 2 consecutive columns on the first sheet.
If my understanding is correct then I can get this done in less than an hour.
My approach ( ie, if my understanding is correct ) -
User select an item from the dropdown.
The Macro searches for the 'EXACT" text on the next sheet and gets the translated text from the corresponding ROW ( col 2 & 3 ) and updates it in the corresponding columns in the first sheet.
Please confirm and do contact me. I willing to stand corrected if my understanding is wrong
Regards