drop down lists can easily made by means of named ranges inside the same workbook/sheet.
Can I use this option also with data in an external data sheet ?
The source field in the data validation tool won't allow me to use external references
is this correct ?