Brandon002
New Member
- Joined
- Mar 5, 2010
- Messages
- 6
I'm creating a database for files at work. In each "job folder" there are sub folders. I have a column that is titled "available file sets" which I want to have a drop-down list that shows ONLY the files sets that are actually available. I understand completely how to make a drop-down list using specific cell information, but in my case, the information changes from job to job and i do not want to create 20 different lists in order to use Data Validation. Is there a way to add a drop-down list where i can change the items for each job i have without selecting information with other cells.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Example:
Say in Column "A", i have my drop down list. It will extend all the way down the sheet. The Items, or "file sets" in the drop down are the following: Architect, contractor, general, legal, invoices, requisitions, progress schedule, meeting minutes, testing, change orders, and subcontractors
Each Row is a DIFFERENT job(610 to be exact), and may not have all those items in the file set. So i need a way to pick and choose which ones i want in the drop-down list for each job without having to create 20 lists so when i use Data Validation, i'm not limited to selecting a range of cells.
Does this help?
Brandon <o></o>
<o> </o>
Example:
Say in Column "A", i have my drop down list. It will extend all the way down the sheet. The Items, or "file sets" in the drop down are the following: Architect, contractor, general, legal, invoices, requisitions, progress schedule, meeting minutes, testing, change orders, and subcontractors
Each Row is a DIFFERENT job(610 to be exact), and may not have all those items in the file set. So i need a way to pick and choose which ones i want in the drop-down list for each job without having to create 20 lists so when i use Data Validation, i'm not limited to selecting a range of cells.
Does this help?
Brandon <o></o>