• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1007
  • Last Modified:

Multiple Choice Drop Down Menu

HI,

I'm a new here. I have a question please.

First, i'll do this with Excel 2010 but I really need the formula or whatever to be compatible with Excel 2003 because the person this is for has Excel 2003.


I have a volunteer's list for a charity. One column is called "Help Areas", with different options:

Fundraising Activities
Food Bank Centres
Maintenance / DIY
Driving, Heavy Lifting
Administration / IT

I'd like to have a drop down menu with all the choices above BUT also being able to choose multiple options for each individual.

Also, if possible, I'd like these options to be selectable in the sort field at the top (see screenshot attached).

Thank you so much for your much appreciated help.
expert-exchange.jpg
0
scot-land
Asked:
scot-land
1 Solution
 
NBVCCommented:
Here is a link that might help with the multiple choice data validation:

http://www.contextures.com/excel-data-validation-multiple.html

As with the drop down at the top, you should already be able to make multiple selections to filter by...
0
 
scot-landAuthor Commented:
ok thnx
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now