Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

link combo selection to data

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'
dashboard-wip.xlsx
0
singleton2787
Asked:
singleton2787
1 Solution
 
SiddharthRoutCommented:
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"

Sid
0
 
sdwalkerCommented:
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,

sdwalker
dashboard-wip-sdw.xlsx
0
 
gowflowCommented:
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.

dashboard-wip-1-.xlsm
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
singleton2787Author Commented:
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!
0
 
sdwalkerCommented:
It works on mine.  Are calculations turned on?  I'm not sure why you're not seeing it.
0
 
gowflowCommented:
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
gowflow
0
 
gowflowCommented:
Sorry my mistake here it is try this version when you select an item it populates rightaway
rgds/gowflow
dashboard-wip-1-.xlsm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now