Validation

[Guest]

Hi,

I want to use a list in diffrent sheet as validation in another sheet. However I can only select a datarange in the sheet where I wan the validation box.
Does anybody have a solution for this?


rgds


Johan

 

[Aladin Akyurek]

Select the range that constitutes your list, go to the Name Box on the
Formula Bar, type SList, and hit enter. Now you can use SList as source in
data validation anywhere in the same workbook. Just enter:

=SList

in the Source box after selecting List for Allow.

Hi,

I want to use a list in diffrent sheet as validation in another sheet.

However I can only select a datarange in the sheet where I wan the
validation box.

 

[Paul B]

Johan, To use a list on another worksheet, name the range ex. mylist and in
the source box put =mylist
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

Hi,

I want to use a list in diffrent sheet as validation in another sheet.

However I can only select a datarange in the sheet where I wan the
validation box.

 

[Jason Morin]

You'll have to define a name that represent your range if
it's on another sheet (or workbook). MVP Debra Dalgleish
has some instructions for Data Validation:

http://www.contextures.com/xlDataVal01.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

I want to use a list in diffrent sheet as validation in

another sheet. However I can only select a datarange in
the sheet where I wan the validation box.

 

[Lara]

I generally pick an unused area in the sheet and put
links there to the other sheet, where the original list
resides. Then use THAT range for my list in the
validation.

-----Original Message-----
Hi,

I want to use a list in diffrent sheet as validation in

another sheet. However I can only select a datarange in
the sheet where I wan the validation box.