Dynamic Drop-down List for Data From a Separate Sheet|Dashboards & Charts|Excel Forum|My Online Training Hub

Greetings,

I researched the Internet for assistance first, but couldn't find something to meet the need. So, I am hoping you folks can help.

The uploaded file is for part of a new dashboard. The goal of this part of the dashboard is to have the End User select a single Document Name from the drop-down in the "Dashbd Prep" tab. Then all document information about that Document Name populates in the columns from the raw data. The items in the columns will change as the end user selects different Document Names from the drop-down list.

This way, the End User sees all information in the columns about one Document Name that is listed multiple times in the raw data. This will help them to retrieve the particular document on a particulate date, from a particular box in storage, which is very useful and time-efficient in audit situations.  They may need to filter to find document information quickly.  

The Document Drop-down list ("Dashbd Prep" tab) has already been created with the use of a Pivot Table (see the "Pivot" tab). I noticed that when I tested adding a new Document Name, it automatically placed the new Document name at the bottom of the drop-down list in the "Dashbd Prep" tab. Is there a way that the drop-down list always remains in descending order when new items are added?

Please notice that not all of the columns from the raw data will be displayed on the dashboard. Also, the dashboard needs to remain as simple and straightforward as possible, which is why I am shying away from slicers.  Additionally, if I made a slicer for the "Box" column, I would have to create a new slicer each time a new box is added to storage.  I would prefer the dashboard updates without needing additional work.  Keeping that in mind, how do the columns on the "Dashbd Prep" tab get populated dependent on what is selected in the drop-down list in B3?

If you have any questions or concerns, please do not hesitate to contact me.

Thank you,

Karlin