data validation and indirect

No, you can't put that into the "source" field for data validation, so you're stuck copying down.

Thank you Bentleybob. You've just ended my hours of searching for an answer :-) May I say, definitively.