How to create lists of data quickly from a pre-existing database

[TAL27]

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, ***, 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

[bigwheel]

Take a look at Filtering - probably the easiest option if you're new to Excel

"TAL27" wrote:

>
> 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, ***, 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
>
>

[Sivassou]

Hi,

you can also use PIVOT TABLE, to get in seperate sheet.

Try it out.

-Sivassou.

"TAL27" wrote:

>
> 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, ***, 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
>
>

[TAL27]

I don't want to just find/filter the data, I want to find particular data in a cell, then copy across data from a cell adjacent to it, for example if someone has 'Male' written in the gender column, I'd want their name copied from the adjacent 'Name' column to a new list of all men.