Data Validation Question
Give the structured reference a defined name:
Name: List
Refers to: =tblEmployees[Name]
Then as the source for the drop down use =List
I want to go off on rant here but I'll bite my tongue! <g
--
Biff
Microsoft Excel MVP
"Steve Haack" wrote in message
...
If I have a range of data that I have created as a Table in Excel 2007, is
it
possible to have Data Validation point to that using the naming convention
that you can use for referencing tables?
For example, I have a tabel named tblEmployees and I have 2 columns named
EmpID and Name.
I want have some cells with Data Validation and I want to have them select
from a list. I woud like to set the Source on the data validation to:
=tblEmployees[Name] but it won't let me. It makes me use either basic
range
names, or the cell references, each of which are not as dynamic as a
table.
Thanks,
Steve
|