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 29

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.

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!


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 29

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 29

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

726 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