Link to home
Start Free TrialLog in
Avatar of chitralekhaa
chitralekhaa

asked on

MS Excel VBA

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
cluster-server-table.xls
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chitralekhaa
chitralekhaa

ASKER

Thank you so much for the this code. It is going to be a great help and you made it so easy.
Thanks
Thanks, chitralekhaa!