Debra's site also shows how you can have a third dependent drop-down,
but if you only have one Production Manager then you can use VLOOKUP -
Debra gives full details on her site.
Hope this helps.
Pete
On Jan 21, 9:57*pm, djs wrote:
It worked great Eduardo and Pete. Thanks alot for the tips.
I just have one more question: How can I make it that when I select
something from a drop down list in B2 Cell D2 would have the correct answer.
e.g. A2 - Dept. Heads is selected from list. B2 - Production. C2 would have
the name of the production Manager.
Hope someone can help me with this one.
djs...
"djs" wrote:
Thanks guys.
Will let u know how it works out for me
"Pete_UK" wrote:
Debra Dalgleish shows how you can achieve your first requirement he
http://www.contextures.com/xlDataVal02.html
As for your second query, have you tried highlighting the data and
using Data | Sort ? You can sort on up to 3 fields of data (columns)
and choose ascending/descending order for each of those fields.
Hope this helps.
Pete
On Jan 21, 5:01 pm, djs wrote:
I need some help.
Ive got a very large woork sheet and would like ot break it down so I dont
have to do alot of typing. Here is what I would like to know if its possible.
1. Ive created a number of Dropdown list, but wanted to know if when I
selected a particular item from from list in cell B2 cell D2 would
automatically be populated by the correct list? *e.g. Department Heads are
selected in B2 only the pre-assinged names would appear in a drop down list
in cell D2. and so forth.
2. How do I do a sort by text or would I need to put a number infront of the
text for it to work. eg. Say I had a sheet of 1000 employess by department,
positions,yrs of service and so on. How could I sort out only the Department
Heads or say job lvls?
Ive tried many different formulas but they would work for part but not all.
Help would be greatly appreciated.- Hide quoted text -
- Show quoted text -