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

T

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 lo
attendance data for their employees. I've got a database which ha
loads of info on people - age, sex, section they work in etc - ideall
I want someone to be able to type in 'male', and have excel go an
interrogate the database (currently on a separate worksheet) and creat
a list of all the male employees. Is this possible?

Cheers,

To
 
G

Guest

Hi,

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

Try it out.

-Sivassou.
 
T

TAL27

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Newbie trying to create Access Database for survey data 0
How can i create a form linked to a database 3
Access how to open existing database from another database using Access - VBA 0
Use of pre-defined lists 3
Need help using data from multiple worksheets to create a Summary 3
How to create Dropdown lists not using Data Validation 2
How to Create Database from Single Column of Data 2
How To Use Range Names In Data Validation Criteria (Not For Lists) 1

Top