HTSNY_JACK
New Member
- Joined
- Nov 19, 2013
- Messages
- 4
Hi - I am trying to fine-tune a scheduling spreadsheet for my company's 2014 work. We have projects organized by specific areas, with varying numbers of projects in each area. My goal is to organize the spreadsheet so i can select an area from a drop-down list in column A, which will result in a corresponding set of options to select from in a drop-down list in column B. I have my spreadsheet set up this way, so far. Once the selection is made in column B, the rest of the row is populated with corresponding data.
The function that i would like to incorporate is this: if there are 3 jobs in area A, and i select job 1 in row 7, for example, when i select area A in row 8, how can i set things up so that the only options that i am shown in the drop-down list are jobs 2 and 3? In other words, as we work through our 2014 schedule (the workload is static, there will not be new jobs added throughout the year) and i plan out our schedule a couple weeks ahead of real-time, there will be fewer and fewer job options available to select because those jobs will have already been selected and scheduled.
I followed a few google search leads for "dynamic drop down lists," but couldn't find anything to explain exactly what i would like to do. I'm not even sure if it's possible, but with everything i've learned about excel (lots from this message board; i received a very informative and helpful answer to a question posted last year, thank you very much!) i believe that ANYTHING is possible. Any help would be HUGELY appreciated! Thank you very much!!
-Jack
The function that i would like to incorporate is this: if there are 3 jobs in area A, and i select job 1 in row 7, for example, when i select area A in row 8, how can i set things up so that the only options that i am shown in the drop-down list are jobs 2 and 3? In other words, as we work through our 2014 schedule (the workload is static, there will not be new jobs added throughout the year) and i plan out our schedule a couple weeks ahead of real-time, there will be fewer and fewer job options available to select because those jobs will have already been selected and scheduled.
I followed a few google search leads for "dynamic drop down lists," but couldn't find anything to explain exactly what i would like to do. I'm not even sure if it's possible, but with everything i've learned about excel (lots from this message board; i received a very informative and helpful answer to a question posted last year, thank you very much!) i believe that ANYTHING is possible. Any help would be HUGELY appreciated! Thank you very much!!
-Jack