select data from worksheet depending on criterions
 

I have one excel file in which there are two worksheets-1 Masterdatabase and
the other is Myteam , the Masterdatabase sheet contains the details of all
the employees like skill, sal , tenure, qualification. I am looking to have
these details pulled out of from the Masterdatabase into the Myteam
worksheet, when i just enter the name of the employees who are in my team ,
all the attributes like skill,sal,tenure, qualification of the corresponding
employees should be auto-populated in the Myteam worksheet

select data from worksheet depending on criterions
 

Hi questmethis

Attached find the file named ExtractNames.xls, it should put you on th
right track.

regards
Zanto

Attachment filename: extractnames.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=69207
--
Message posted from http://www.ExcelForum.com