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
e.g If col A= W03
Then B = IC3
cluster-server-table.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks, chitralekhaa!
ASKER
Thanks