We are creating form in excel and have 2 drop down menus - can you link
options from the first drop down box to the second - Example

Box #1 - has listing of deparment numbers

Box #2 - has listing of account numbers

We would like the outcome to be: Once the department is selected and you
are selecting a account number - we would like "Only" the account numbers
that pertain to that department as the option

You can but you need to program it. See
http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NANCY" wrote in message
...
We are creating form in excel and have 2 drop down menus - can you link
options from the first drop down box to the second - Example

Box #1 - has listing of deparment numbers

Box #2 - has listing of account numbers

We would like the outcome to be: Once the department is selected and you
are selecting a account number - we would like "Only" the account numbers
that pertain to that department as the option

Yes you can, in the second validation, you use a List option and for the
source have something like:-

INDIRECT(HLOOKUP(A1,C1:E2,2,FALSE))

Where A1 is your first List (Department), then in C1,D1,E1, you have
all the possible values of the first validation, then in C2,D2,E2, you
have wriiten as text the reference of the cells which contain account
numbers for the department F1:F5, where F1 has account number 1, F2 has
account number 2, and so on

G


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=536878