Solved

Excel 2013 Drop down help with data

Posted on 2016-10-13
3
58 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

863 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

22 Experts available now in Live!

Get 1:1 Help Now