Results 1 to 4 of 4

Referencing an individual selection from a drop down list

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2018
    Location
    Massachusetts
    MS-Off Ver
    2010 or 2016
    Posts
    1

    Referencing an individual selection from a drop down list

    I have a table of data that is dynamic based on a drop down list, so when a different item is selected the data changes. I would like to have another sheet that summarizes the data in the table across all selections. Attached is a workbook that is not the exact data I am working on, but just to show what my problem is. In cell A2 of the "drop down" sheet I have the drop down list. On the "summary" tab is where I am having the issue. I would like to fill that table out, and cannot figure out what function to use to do so. Let me know if you need more clarification of the problem, thank you all for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-06-2017, 10:19 AM
  2. VBA Hide/Unhide individual sheets based on selection in drop down menu
    By igullage in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-05-2015, 08:01 PM
  3. Replies: 2
    Last Post: 12-10-2014, 12:42 AM
  4. [SOLVED] Range in one drop down list depended on the selection in another drop down list
    By masben in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2013, 10:36 AM
  5. Autolock Cells from a Drop Down List Selection and a Calendar Selection
    By John Anderson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2013, 10:54 AM
  6. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  7. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1