ExcelBanter - View Single Post - Structured references in custom Data Validation expression?

kr/nk[_2_]

Great!

Thx again,
kr/

"T. Valko" wrote:

I'd like to ensure that by expanding Table2, the newly
included rows will be available for choosing
as a value in Table1.

In that case you simply need to make Table2 a dynamic named range.

http://contextures.com/xlNames01.html#Dynamic

Biff

"kr/nk" wrote in message
...
Hi,

Thanks for your answer.

Unfortunately the referenced cells are on other sheet. On the other hand,
I'd like to ensure that by expanding Table2, the newly included rows will
be
available for choosing as a value in Table1. That's why I wouldn' like to
use
a named range. Specifically the best would be to reference a column in a
table without the need of turning its cells into a range or list.

krank

"Peo Sjoblom" wrote:

Select all necessary cells in column X, do datavalidation, allowlist
and
select the cells in column Y, deselect dropdown

--
Regards,

Peo Sjoblom

"kr/nk" wrote in message
...
I'm very keen to know how could I enter a Data Validation expression
using
tables.

I have two sheets with two tables. In a certain column of the first I
need
to restrict the values one can enter to the values entered in a column
in
the
other table.

So for ColumnX in Table1, I'd like to set a custom data validation
expression like:
=Table2[ColumnY]
to tell only values in the ColumnY column are enabled to be entered in
ColumnX.

Is there a way to do this or isn't this stuff supported?