Hi All,

I have a workbook which contains 3 sheets, in sheet 2 & 3 we have near about 500 employee records.

Here what i am looking is,

In sheet 1, if I enter the employee number in A1 and after clicking on the button excel will search the details of the employee from sheet 2 & 3 and will show it to me on sheet 1.

Waiting for the reply.

Regards
Ravi