I need a macro to place value in column B after reading value in column. In the attached file I have set all the values in column B. The report will repeat the values in A and that is where I would like macro to Pick IC1 or IC2 or IC3 for columb. Can the values be hardcoded in the macro ?
e.g If col A= W03
Then B = IC3