I have an excel file in which
sheet 2's A column contains
Old account number B column
contains New account number.
I want that
when i enter an old no in
column A then new no show in
column B of sheet
2.
in this case i need Excel
experts help
please tell me how can i create
a VBA code to do this.
But i dont want to use a Vlook
up formula.
thanks in advance