[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

link combo selection to data

Posted on 2011-02-28
7
Medium Priority
?
219 Views
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'
dashboard-wip.xlsx
0
Comment
Question by:singleton2787
7 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
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"

Sid
0
 
LVL 12

Expert Comment

by:sdwalker
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,

sdwalker
dashboard-wip-sdw.xlsx
0
 
LVL 31

Expert Comment

by:gowflow
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.

dashboard-wip-1-.xlsm
0
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

by:singleton2787
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!
0
 
LVL 12

Expert Comment

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

Expert Comment

by:gowflow
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
gowflow
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 35000461
Sorry my mistake here it is try this version when you select an item it populates rightaway
rgds/gowflow
dashboard-wip-1-.xlsm
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

834 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