Replace word
Good evening,
I want in sheet1(A1:G50), if client 1 (sheet2(cell(A2)) is german (sheet2(cell(B2)) then select cell(A5) and replace with word 'apple',still select cell(C10) and replace with word 'fruit',if client 2(sheet2(cell(A3)) is italian (sheet2(cell(B3)) then select cell(A5) and replace with word 'orange',still select cell(C10) and replace with word 'vegetable'.Final print and save this range.
Could you give an example with code.
|