Excel Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Make sure your columns have column headers or labels, then pull-down:

Data > Filter > Autofilter

This will supply drop-downs as you require.
 
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?
 
You must log in or register to reply here.

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

Excel Brush Up on Excel 1
Meet Mycroft: An Open Source Virtual Assistant 3
Filtering subreports on main report 0
Union Query question 2
formula to return value from a matrix - I know hor and vert values 14
converting column of text to text box for repetitive records 2
Urgent requirement for Senior-Dot net developers @ Hyderabad 0
Creating a Simple Form to Add a Record to a table 1

Back
Top