patrick_oneal
New Member
- Joined
- Nov 14, 2016
- Messages
- 12
Hello All,
Thank you for viewing this message, I hope you can find a better solution for this issue.
Background:
I have to create a schedule that has a data validation list for a specific jobs. My spreadsheet is divided into 3 tabs. The first is a list called Crews that will break out all of my manning into cells B3-B100. I must then divide those names further into job specific crews. I have to maintain a set number of cells to account for incoming manning. I need to make a dynamic list WITHOUT VB, it's disable on my computer, that can remove those blank cells when I create a data validation.
<tbody>
</tbody>
The Crew page will reference those cells:
<tbody>
</tbody>
The zeros represent the cells referencing the Crew sheets: =Crews!B3
I need to find a formula that can dynamically combine those into a single validation that ignores the 0s that are false returns from the other sheet.
kjkhl
Thank you for viewing this message, I hope you can find a better solution for this issue.
Background:
I have to create a schedule that has a data validation list for a specific jobs. My spreadsheet is divided into 3 tabs. The first is a list called Crews that will break out all of my manning into cells B3-B100. I must then divide those names further into job specific crews. I have to maintain a set number of cells to account for incoming manning. I need to make a dynamic list WITHOUT VB, it's disable on my computer, that can remove those blank cells when I create a data validation.
Names: |
Bob |
Sarah |
Frank |
Ralphie |
<tbody>
</tbody>
The Crew page will reference those cells:
Monday |
Crew 1 |
Ralphie |
0 |
Crew 2 |
0 |
Bob |
Crew 3 |
Sarah |
0 |
<tbody>
</tbody>
The zeros represent the cells referencing the Crew sheets: =Crews!B3
I need to find a formula that can dynamically combine those into a single validation that ignores the 0s that are false returns from the other sheet.
kjkhl