Dear Friends,
Enclosing herewith a spread sheet (Record Insert) with 2 sheets.
MASTER
WORK
I am using vlookup individually for every row.
Pl help me for a Macro:
Master data is available in MASTER Sheet
Emp ID is keyed in Column B
Other column values of WORK have to be picked-up from master.
CONDITIONS:
In case of repetition value of EMP ID (B column) error message
If EMP Id does n't exist in MASTER- Error Message.
Regards
Srinivas
Bookmarks