link combo selection to data

Posted on 2011-02-28
Last Modified: 2012-05-11
I wish to display data from one sheet to another based on a drop down list (I used Data Validation and a named range (NAMES on DATA!)
The end result is that on the sheet labeled 'new layouts' I want the user to select the person, and the the values from the DATA sheet to populate the 'new layouts'
Question by:singleton2787
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
LVL 30

Expert Comment

ID: 34999723
Could you explain a little more?

When a user selects say "• EMEA Deployment – Pieter" from the list what should happen? Similarly for say "• APJ Deployment – Jackie"

LVL 12

Expert Comment

ID: 34999885
I thought I submitted a response, but it apparently didn't come through.  You can hardcode the numbers in the left-hand column if you like.  You could also use an IF statement to eliminate the zeroes where the data is blank.

Good luck,

LVL 30

Expert Comment

ID: 35000021
Is this what your looking for ? select your item the click on the item you will see the data beneith it in the fields in New Layouts sheet. Sorry don't know what kind of control you hv there htis is why could not trap the dropdown event to display data.

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.


Author Comment

ID: 35000208
gowflow and others, that is almost it. The only problem is that when I select the name from New Layouts!C3 the data below doesn't populate unless I step off the field, and then select it again. Is there a way to fix this? Thanks!
LVL 12

Expert Comment

ID: 35000269
It works on mine.  Are calculations turned on?  I'm not sure why you're not seeing it.
LVL 30

Expert Comment

ID: 35000445
Well I told you when you select the item in the combo click on the cell again it will populate the data. It is not the best thing but pls advise how did you get this combobox there ? and what type is it maybe I can get you somehting better
LVL 30

Accepted Solution

gowflow earned 500 total points
ID: 35000461
Sorry my mistake here it is try this version when you select an item it populates rightaway

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

687 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