Could you please help me with a macro to migrate data one excel to other. I have two excels one contains the reference list of values. i want to migrate the datas from another excel to map to the corresponding refrerence value. is it possible with macros? now i am using vlook for the same.