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

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

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

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

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

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

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

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.


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