Data Validation Question

S

Steve Haack

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
 
T

T. Valko

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
VLOOKUP & Data Validation 0
Excel - Wich Function should I use? 1
Data Validation 4
Data Validation List Names 2
custom data validation on cells with data validation values 2
using indirect to return a named range? 1
Testing a cell value for a specific weekday. 4

Top