Solved

Excel 2013 Drop down help with data

Posted on 2016-10-13
3
72 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 31

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 31

Expert Comment

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

Featured Post

Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

Question has a verified solution.

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

Outlook Free & Paid Tools
Use Windows Task Scheduler to print a Word document weekly so your printer ink won't dry out.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

734 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