Independent Drop-Down List

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-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p> </o:p>
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:p></o:p>
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top