Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel 2013 Drop down help with data

Posted on 2016-10-13
3
Medium Priority
?
82 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 33

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 2000 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 33

Expert Comment

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

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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.

783 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