Hi Friend,
i m facing 1 little problem.
see below:
COLUMN-A COLUMN-B
LY00001 INDIA
LY00002 PAKISTAN
LY00003 CHINA
LY00004 USA
LY00005 BANGLADESH
LY00006 AUSTRALIA
LY00007 SHRILANKA
LY00008 NEWZILAND
MORE... MORE...

IN ANOTHER SHEET:
COLUMN-A COLUMN-B
LY00005
LY00005
LY00001
LY00004
LY00009
LY00056
MORE.....

NOW I WANT REPLACE (LIKE: LY00005 TO BANGLADESH, ETC) WITH ONE COMMAND.

PLS TREAT THIS MATER IS URGENT.


NOW I WANT TO REPLACE