Results 1 to 4 of 4

'Select all' option in a drop down list

Threaded View

james19 'Select all' option in a drop... 03-12-2016, 08:38 AM
azumi Re: 'Select all' option in a... 03-12-2016, 08:47 AM
james19 Re: 'Select all' option in a... 03-12-2016, 09:16 AM
newdoverman Re: 'Select all' option in a... 03-12-2016, 11:14 AM
  1. 03-12-2016, 08:38 AM #1
    james19 is offline
    Registered User
    Join Date
    02-26-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    46

    'Select all' option in a drop down list

    Hi,

    I'm doing a sumif based off the data selected in a drop down list but I need a 'select all' option. So I need there to be an 'all' option in the drop down list which adds all the data in the list. Any help would be greatly appreciated guys. I've added an Excel sheet that further explains the problem.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data validation drop down select all option
    By MrAlex in forum Excel General
    Replies: 3
    Last Post: 01-05-2015, 10:54 AM
  2. [SOLVED] How do I date stamp different fields each time I select an option from a drop down list?
    By martyparke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2014, 05:47 AM
  3. Select option in HTML drop down list
    By JohnsonJiang in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-15-2014, 03:28 PM
  4. Filtering - user select single option from drop-down list?
    By shreksbro in forum Excel General
    Replies: 4
    Last Post: 02-07-2014, 12:49 AM
  5. [SOLVED] If I select an option from a drop-down in 1 cell, how do i get it to display specific info
    By Posthuman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2012, 01:45 PM
  6. Can only select a drop down option once
    By davidstokes in forum Excel General
    Replies: 27
    Last Post: 02-22-2012, 09:55 AM
  7. multiple select from the drop down list in excel. list in one sheet and drop down in
    By sriramus in forum Excel General
    Replies: 5
    Last Post: 10-27-2005, 01:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1