Excel Query

A

Alison

I have a large excel spreadsheet that contains skills and skill levels of
consultants. Is it possible to create some kind of form within Excel that
has a Skills drop down box at the top. When you select the skill you require
it looks at the data and displays only the people who have that skill and the
skill level?
Thanks,
 
G

Gary''s Student

Make sure your columns have column headers or labels, then pull-down:

Data > Filter > Autofilter

This will supply drop-downs as you require.
 
A

Alison

Apologies I didnt explain myself very well. I have two spreadsheets one has
internal skills and one has partners skills. I want to create a front page
where I can select a skill and it will look at the two spreadsheets and
extract for internal resources, names and skill levels and for the partners,
names, skill levels and contact details. Is this possible in Excel or would
Access be better?
 
Top