The first cell in each column of employee names should be named for the
department. For example, cell F1 might be named "Accounting"

Each column of employee names should be named Dept&Col. For example,
column F would be AccountingCol

Then, in the dependent validation, you refer to the cell with the
department name (cell E2 in this example):

=OFFSET(INDIRECT($E2),0,0,COUNTA(INDIRECT($E2&"Col ")),1)

If your deparment names contain spaces, or some other characters, you'd
have to adjust the names and formulas.

Annie wrote:
Yes, I have followed the infor for Dynamic Lists. I have my first drop down
for Departments (A1:A10) and I have named several columns (F,J,H,I) with
employees listed. I do not think I am entering the formula correctly.


"Debra Dalgleish" wrote:


Did you try the instructions for dynamic lists?

http://www.contextures.com/xlDataVal02.html#Dynamic

If so, where are you getting confused?


Annie wrote:

I have set up a drop down in my first column lsiting 10 company departments.
In the second column I would like a drop down showing the employees for the
specific department selected in the first column.

I have looked at the info on the Contextures site, and I am certain I need
to do a Dynamic list since employees can change, but I I am still confused.
I would appreciate any help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html