Solved

Excel 2013 Drop down help with data

Posted on 2016-10-13
3
46 Views
Last Modified: 2016-10-14
Good afternoon,

I have an excell spread sheet (see attached). One sheet is a master data sheet. The other is the CP_ownership sheet. As you can see on the master data sheet under the domain column a good portion of the data is repatative. What I would like to do on the CP_Ownership sheet is create a drop down under the Domain column that will only show possible repative domains only one time and when selected populate the rest of the sheet with the appropriate information. I have no clue on how to make this happen. I hope that makes sense. I did create a result 1 and result 2 tab to show you what I'm looking for from a result stand point in the event I was not clear. Also keep in mind the master list can grow over time. Thanks!
CostPoint_OwnerShip.xlsx
0
Comment
Question by:DJ P
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
ID: 41843101
I have used VBA to achieve the desired output.
In the attached, select the Domain and Model from the drop downs in the yellow cells and the relevant data will be populated on the sheet.

Remember this is macro enabled workbook so you will need to enable the macros when prompted.
CostPoint_OwnerShip.xlsm
0
 

Author Comment

by:DJ P
ID: 41843702
Awesome! Thank you so much!
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41843814
You're welcome DJ P! Glad to help.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Outlook Free & Paid Tools
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

757 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

14 Experts available now in Live!

Get 1:1 Help Now