Solved

Excel 2013 Drop down help with data

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

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 30

Expert Comment

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

679 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