Considering all the things you don't want to do, then this becomes "work
intensive".

What you'd have to do is make a separate list for each unique vessel with
its departure dates then use that data as the source for your drop down.

--
Biff
Microsoft Excel MVP


"Reacher21" wrote in message
...
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.