I can't see a solution on contextures.com or here so hoping someone can put
me out of my misery!
I have a master list of vessel names on Sheet1 Column A. On Sheet2 is my
data repository where I record all voyages of vessels I'm tracking and some
vessels make multiple voyages differentiated by a different departure date.
The vessel name for each voyage is chosen by validated drop down based on
list in sheet1. Next to that is the departure date and other details related
to cargo etc.
On Sheet3 I wish to use a template invoice which has a drop down for vessel
name, and then a drop down to choose from the departure dates related to the
chosen vessel. The data on Sheet2 is sorted by departure date and I would
like to keep it that way for other reasons. I set up contextures' solution
for sorted list only to realise that it must be sorted by the vessel name. I
don't want to use pivots or macros if I can help it. Thanks for any help.