+ Reply to Thread
Results 1 to 7 of 7

Displaying dashboard information with validation drop down list

  1. #1
    Registered User
    Join Date
    06-05-2014
    Posts
    13

    Displaying dashboard information with validation drop down list

    Hello all,

    I have a project I'm working on that requires me to display information from various sheets on a dashboard. I have created a data validation dropdown list with part numbers. When one of these part numbers is selected from the drop down list I need the rest of the fields to populate with the appropriate information from various sheets in the workbook. How do I tell the dashboard to display this information per part number?

    Please see the attached workbook.

    thanks!Mini-Project Wally Mart (B212-10).xls

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Displaying dashboard information with validation drop down list

    Hi Hello Mr etc.... Confused. There's a cell that looks like it has a dropdown (dashboard CDE6), but nothing drops down. There's no data validation associated with it, either. Did you attach the correct sheet?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Displaying dashboard information with validation drop down list

    Me again. There was something very odd with cell CDE6 (apart from the fact that it was a merged cell - PLEASE DON'T USE THEM...). There seemed to be two dropdown components in the box, one of which gave my list of part numbers and one which gave nothing. So I copied the sheet & killed the merged cells.

    Anyhow. this is a "work in progress", not the end result.. the Dropdown now populates the cells below it. So what do you want to do next?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-05-2014
    Posts
    13

    Re: Displaying dashboard information with validation drop down list

    Thank you! I'm not sure why that validation didn't work initially but what you did looks good. Now I need to populate the rest of the dashboard (all green and grey cells) with the appropriate information per part number.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Displaying dashboard information with validation drop down list

    OK. There may be more Qs later, but in the meantime, can you mark this thread as solved and (preferably) click the Add Reputation button at the foot of this post?

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Displaying dashboard information with validation drop down list

    Cheers! Keep the Qs coming...

  7. #7
    Registered User
    Join Date
    07-10-2015
    Location
    Rexburg, Id
    MS-Off Ver
    2013
    Posts
    1

    Re: Displaying dashboard information with validation drop down list

    I'm really struggling with this same project. How to you get the low forecast, expected forecast, etc. to change with the item number? And also, how do you get the data field to report the first day of the current month?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-17-2012, 01:18 PM
  2. Replies: 3
    Last Post: 05-19-2011, 03:08 AM
  3. How to feed dynamic information to a drop down List (Validation Feature)?
    By kscramm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2006, 07:15 AM
  4. How to reference list using a drop down menu, displaying the list
    By eddiespaghetti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 04: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