Get Free, Friendly, Expert Advice
Call 1-866-244-8796 or email

Designed and Manufactured in Canada Since 1980


AxiomAudio Blog

Blind Listening Tests

Sneak Peek into Axiom’s Current Research and Development

Axiom’s Newest Speaker: The In-Ceiling M3

Wall'O'Fame
Experimental Atmos
Greetings fellow Axiom owners...
Who's Online
3 registered (onn, brwsaw, brendo), 47 Guests and 6 Spiders online.
Key: Admin, Global Mod, Mod
Financing
Forum Stats
13323 Members
11 Forums
22902 Topics
404778 Posts

Max Online: 378 @ 02/24/13 04:33 PM
Top Posters
Ken.C 17783
pmbuko 16282
SirQuack 13337
CV 11212
MarkSJohnson 10911
Meanwhile On Facebook

Ian and Andrew join in the debate about whether or not people want uncompressed...

󾓶 The first review of the LFR880s is out! "If you are adding or upgrading stere...

So much going on in this month's newsletter - new product announcements, a new v...

Topic Options
Rate This Topic
#393701 - 06/04/13 11:31 AM Need Excel help
Murph Offline
axiomite

Registered: 10/05/06
Posts: 6841
Loc: PEI, Canada
There seem to be some real Excel Gurus here so I thought I'm hoping to take advantage. I spent a couple of hours trying to get the various (and all different) samples I've found on the Internet going, but no luck.

Here goes.
Excel 2010
I have a 'Master Projects list" table with two columns that I need to refer back to on several other worksheets. To keep it simple, I'll use "Customer" and "Projects" as the column headers in this example. I have given each column a [defined name] matching the above. For example (and ignore the dots)....

Customer........Projects
DAU Ltd.........Managed Firewall
DAU Ltd.........BID Internet
Grover & Co....Study super powers

On another worksheet, I want to create, say a To-do List, where I can fill in the columns via dropdown lists using [data validation] from the above columns.

Here I will have
Customer......Project.......Task

To enter a new task I will pick a blank row, click in the Customer column and be presented with a dropdown list of all customers based on the list from the first sheet.

HERE IS WHERE I NEED HELP.
Then I would click on the Projects column and I wish to also have a dropdown list but I wish to be presented with only the projects that are associated with my choice in the customer column.

I know how to use [Validate Data] to create a dropdown list but I can not figure out the formula to use in the
'Source" field that will limit the drop down list based on the previous cell.

For the sake of simplicity, lets say all this exists on the same worksheet. I can add the worksheet names in later once I get it working on the same page.

Thanks any and all who can help!
_________________________
With great power comes Awesome irresponsibility.

Top
#393719 - 06/04/13 03:46 PM Re: Need Excel help [Re: Murph]
pmbuko Offline
shareholder in the making

Registered: 04/02/03
Posts: 16282
Loc: Leesburg, Virginia
I found this page, which seems to lay it all out pretty well.

http://www.get-digital-help.com/2010/07/...alues-in-excel/

EDIT: I just tried this myself and it worked, but only for one instance of first drop-down. Hmmm....


Edited by pmbuko (06/04/13 03:53 PM)
_________________________
"I wish I had documented more…" said nobody on their death bed, ever.

Top
#393739 - 06/05/13 12:52 PM Re: Need Excel help [Re: Murph]
Murph Offline
axiomite

Registered: 10/05/06
Posts: 6841
Loc: PEI, Canada
Thanks Peter!!! Very much appreciated.

I didn't get it working on my first try but there are so many opportunities for syntax errors that I will have to try again after work when I have more time to concentrate.
_________________________
With great power comes Awesome irresponsibility.

Top
#393743 - 06/05/13 01:51 PM Re: Need Excel help [Re: Murph]
tomtuttle Offline
axiomite

Registered: 06/20/03
Posts: 8292
Loc: Tacoma
Hurry up! I'm dying to hear The Answer.
_________________________
bibere usque ad hilaritatem

Top
#393746 - 06/05/13 01:57 PM Re: Need Excel help [Re: Murph]
pmbuko Offline
shareholder in the making

Registered: 04/02/03
Posts: 16282
Loc: Leesburg, Virginia
I found a much better tutorial that makes it a lot simpler. The secret, it seems, is using the '=INDIRECT' function when defining the dependent drop-down lists.

http://blogs.office.com/b/microsoft-excel/archive/2009/11/24/create-conditional-drop-down-lists.aspx
_________________________
"I wish I had documented more…" said nobody on their death bed, ever.

Top
#402803 - 04/10/14 12:44 PM Re: Need Excel help [Re: pmbuko]
tomtuttle Offline
axiomite

Registered: 06/20/03
Posts: 8292
Loc: Tacoma
Here's one I liked and am using.

http://www.contextures.com/xlDataVal13.html

BUT - I need more help.

I have a table of available values with columns for name and ID

Name - ID
Joe Smith 1234567890
Suzy Jones 2234567890
etc.

I want a user to be able to select the NAME in the drop down, but at the same time I want the ID to also populate in another column of the same row.

I WAS putting the name in the validated drop-down cell and then going back to search for the ID based on name, but that won't work 100% because names aren't unique.

I also thought of just concatenating the Name and ID and putting them in the same field.

I don't really do VBA, but I'm fearless with formulas.

Any ideas?
_________________________
bibere usque ad hilaritatem

Top



Moderator:  alan, Amie, Andrew, axiomadmin, Brent, Debbie, Ian, Jc 

Home  |  Corporate Info  |  Products  |  Message Board  |  FAQs  |  Warranty  |  Site Map  |  Privacy Statement   |  Contact Us

©2014 Colquhoun Audio Laboratories Limited
All Rights Reserved.