Lookup values across multiple sheets

[Thomas Kuriakose]

Dear All,

We have an Employee work schedule. The data for each employee is fed date wise in a single sheet. There are 88 employees and there are 88 sheets.

The values entered are commission number and the respective codes worked in a day.

In the Lookup table we need to check commission wise the employee details, the relevant codes they worked upon and the corresponding date.

It is possible that two employees can work on the same commission number an on the same codes, then the lookup table should give all such values based on the commission number.

kindly help to get the data.

Thanks,

with regards,
thomas

 

[Thomas Kuriakose]

Dear All,

I found a macro in the net, for lookup.

Kindly help if this can be used to extract the data.

thanks,

with regards,
thomas