Multiple Choice Drop Down Menu

Posted on 2012-09-21
Last Modified: 2012-09-22

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.
Question by:scot-land
    LVL 23

    Accepted Solution

    Here is a link that might help with the multiple choice data validation:

    As with the drop down at the top, you should already be able to make multiple selections to filter by...

    Author Closing Comment

    ok thnx

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now