A friend wants the list of potential choices to be on a different worksheet
than where he is choosing the value, via data, validation, list. I told him
to merely echo that list onto the current worksheet but he thinks that is
too inelegant!

It seems that EXCEL's help suggests if you somehow range name the list, it
can be on another worksheet, but it doesn't seem to work. Any suggestions,
including simple techniques (non macro) other than data, validation, list?