Data Validation - Conditional List Boxes
Posted by Jeremy on January 05, 2001 12:47 PM
This is an addendum to my original post (located below).
The list box is partially working. The problem is that the Department Numbers are formatted as follows:
1 - Finance
2 - Sales
For some reason, the formula I was given (from this site) doesn't recognize text....only numbers. Is there a way around this?
Here's the data:
I have a list of department numbers (1-44) and within each department number are numerous unit numbers. For instance, Department 1 is made up of unit numbers 70 - 300 (the unit numbers are listed in 10's; i.e., 70, 90, 120, etc).
Here's the question:
I have already created a list box using Data Validation that lists all the department numbers. Now, I the Unit Number list box to only list the unit numbers that correspond to a particular department. For example, if the user selects department 1, then I want the unit number list box to only list the units that are associated with Department 1. Currently, my list box contains EVERY unit in our company.