[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


link combo selection to data

Posted on 2011-02-28
Medium Priority
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 31

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.

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


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 31

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 31

Accepted Solution

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

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

650 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