I have two excel sheet (one is for keeping the mapping and other is workbook to be worked on). My requirement is to populate the column of workbook excel based on the values stored in mapping excel.
For example: In attached images, mapping excel has stored values (Column for respective codes (Column A). I need to populate the Column B values from mapping excel to Column C in workbook excel depending on the code (Column of workbook excel.
Any suggestion on achieving the same?