Jon

Maybe check out Debra's site for creating dynamic named ranges so's blank cells
are not included.

http://www.contextures.on.ca/xlNames01.html#Dynamic

And this page may help.

http://www.contextures.on.ca/xlDataVal13.html


Gord Dibben MS Excel MVP


On Tue, 29 Apr 2008 22:06:52 +0200, "Per Jessen" wrote:

Hi

The short answer is Yes.

If you want to have your validation list in another sheet, you have to name
the range and then in Source field enter the name refering to the validation
table.

Include a number of empty fields in your named range and check Ignore blank
in the Data Validation window.

Best regards,
Per

"Jon" skrev i meddelelsen
...
Is it possible to create a data validation list using a table for the
list? I can change sheets and select a range in the colum, but if the data
in the table increased then the formula would have to be adjusted every
time.