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.
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)....
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
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.