title: Excel: How to set list data validation to point to a column in a named range
body: <p>I have a named range called "items" spanning 3 cols and 10 rows. In another worksheet I have a cell that uses a data validation list to allow a user to select from a drop down. In the source I want to specify the first column of the named "item" range. Is this possible? </p>