Hi

Could someone show me the codes for the following problem?

I want a Macro that should do the following?

If cells(1,1)="abc" then I want cells(1,2) to show 123
If cells(1,1)="bac" then I want cells(1,2) to show 213
If cells(1,1)="cba" then I want cells(1,2) to show 321

Thanks.

M Varnendra