PDA

View Full Version : Data Validation: Listbox



surya prakash
05-15-2008, 12:43 AM
Hi,
I have a drop-down box in a cell using data validation..
I am wondering if it is possible to input the "Source" of the Data Validation from other sheet using range names..

thanks

Bob Phillips
05-15-2008, 03:12 AM
Yes, exactly as you describe it.

Asterix
05-15-2008, 04:51 AM
I am doing exactly this, but am getting the "...you may not use references to other worksheets..." error.

Annoyingly, I got round this before, but can't remember how.

Bob Phillips
05-15-2008, 04:54 AM
As mentioned in the original pots, you have to create a defined name for the raneg in the other sheet, and use that name in the DV.

Asterix
05-16-2008, 12:06 AM
Ta, your reinforcement pointed me in the right direction.

The name had been defined but between splitting the sheets into separate workbooks and sending them around the t'interweb before receiving them back and then re-amalgamating them into 1 workbook, the external sheet named ranges had got prefixxed with the name of the temporary C: file used when saved as separate sheets from email.

Oh well, fixed now.