Hope someone can help - I'm very new to excel.

I'm trying to set up an idiot-proof file in which people can log
attendance data for their employees. I've got a database which has
loads of info on people - age, sex, section they work in etc - ideally
I want someone to be able to type in 'male', and have excel go and
interrogate the database (currently on a separate worksheet) and create
a list of all the male employees. Is this possible?

Cheers,

Tom


--
TAL27
------------------------------------------------------------------------
TAL27's Profile: http://www.excelforum.com/member.php...o&userid=30145
View this thread: http://www.excelforum.com/showthread...hreadid=498295