Aussie Chris
New Member
- Joined
- Jul 4, 2016
- Messages
- 3
Hi,
I have a table (simplified below) where I am tracking shipping containers.
Id like to create a drop down list (using conditional formatting) of container numbers where the status is not set to DELIVERED on a separate sheet. The idea being that I can create an auto filling container weight declaration from the data in the appropriate rows of the table. The biggest problem I have is that the table currently has over 200 records which makes scrolling the drop down list very tedious. What I'd like to do is exclude any containers from that drop down list where the status is set to DELIVERED. This would reduce the size of the drop down list by more than 90% making it a little more manageable.
The only solution I have come up with thus far is to base the drop down list off a query that filters out the DELIVERED containers but this requires the need to refresh query each time new records are added to the table.
Is it possible to simplify this to remove the need for a query and without resorting to VB?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Container Number[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]AA11[/TD]
[TD]DELIVERED[/TD]
[/TR]
[TR]
[TD]BB22[/TD]
[TD]DELIVERED[/TD]
[/TR]
[TR]
[TD]CC33[/TD]
[TD]DELIVERED[/TD]
[/TR]
[TR]
[TD]DD44[/TD]
[TD]LOADED[/TD]
[/TR]
[TR]
[TD]EE55[/TD]
[TD]EMPTY[/TD]
[/TR]
[TR]
[TD]FF66[/TD]
[TD]LOADED[/TD]
[/TR]
[TR]
[TD]GG77[/TD]
[TD]EMPTY[/TD]
[/TR]
</tbody>[/TABLE]
I have a table (simplified below) where I am tracking shipping containers.
Id like to create a drop down list (using conditional formatting) of container numbers where the status is not set to DELIVERED on a separate sheet. The idea being that I can create an auto filling container weight declaration from the data in the appropriate rows of the table. The biggest problem I have is that the table currently has over 200 records which makes scrolling the drop down list very tedious. What I'd like to do is exclude any containers from that drop down list where the status is set to DELIVERED. This would reduce the size of the drop down list by more than 90% making it a little more manageable.
The only solution I have come up with thus far is to base the drop down list off a query that filters out the DELIVERED containers but this requires the need to refresh query each time new records are added to the table.
Is it possible to simplify this to remove the need for a query and without resorting to VB?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Container Number[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]AA11[/TD]
[TD]DELIVERED[/TD]
[/TR]
[TR]
[TD]BB22[/TD]
[TD]DELIVERED[/TD]
[/TR]
[TR]
[TD]CC33[/TD]
[TD]DELIVERED[/TD]
[/TR]
[TR]
[TD]DD44[/TD]
[TD]LOADED[/TD]
[/TR]
[TR]
[TD]EE55[/TD]
[TD]EMPTY[/TD]
[/TR]
[TR]
[TD]FF66[/TD]
[TD]LOADED[/TD]
[/TR]
[TR]
[TD]GG77[/TD]
[TD]EMPTY[/TD]
[/TR]
</tbody>[/TABLE]