Excel Formulas

[djs]

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.

 

[Eduardo]

Hi ,
Take a look to Debra web
http://www.contextures.com/xlDataVal02.html#TwoWord

 

[Pete_UK]

Debra Dalgleish shows how you can achieve your first requirement here:

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

 

[djs]

Thanks guys.

Will let u know how it works out for me

 

[djs]

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

 

[Pete_UK]

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