Hi All

I have a spreadsheet that has lots of drop down lists using
data-validation-list method.

I was hoping to put the validation material on another worksheet but it does
not seem to let me (I tried manually entering the link but it came up with it
was not able to do this).

Is there away around this or is it just the way it is. Although useful to
have on a separate sheet it is not essential.

Any help or suggestions (even if it is to say you can't!) greatly appreciated

Kind regards

Rexmann

Hi Rexmann,

I was hoping to put the validation material on another worksheet but it does
not seem to let me (I tried manually entering the link but it came up with it
was not able to do this).

Is there away around this or is it just the way it is. Although useful to
have on a separate sheet it is not essential.

Select your source list and give it a name (insert, name, define). Then use
that name as the listsource formula in the data validation, preceded with an
equal sign:

=TheNameYouDefined

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

Hi,

Follow this URL " Excel -- Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

Challa Prabhu

"rexmann" wrote:

Hi All

I have a spreadsheet that has lots of drop down lists using
data-validation-list method.

I was hoping to put the validation material on another worksheet but it does
not seem to let me (I tried manually entering the link but it came up with it
was not able to do this).

Is there away around this or is it just the way it is. Although useful to
have on a separate sheet it is not essential.

Any help or suggestions (even if it is to say you can't!) greatly appreciated

Kind regards

Rexmann

Hi Jan

Thank you very much, worked a treat.

Kind regards

Rexmann

"Jan Karel Pieterse" wrote:

Hi Rexmann,

I was hoping to put the validation material on another worksheet but it does
not seem to let me (I tried manually entering the link but it came up with it
was not able to do this).

Is there away around this or is it just the way it is. Although useful to
have on a separate sheet it is not essential.

Select your source list and give it a name (insert, name, define). Then use
that name as the listsource formula in the data validation, preceded with an
equal sign:

=TheNameYouDefined

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

Hi Challa

Probably more than I need for this one, but looks very interesting for
future projects, so thank you

Kind regards

Rexmann

"challa prabhu" wrote:

Hi,

Follow this URL " Excel -- Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

Challa Prabhu

"rexmann" wrote:

Hi All

I have a spreadsheet that has lots of drop down lists using
data-validation-list method.

I was hoping to put the validation material on another worksheet but it does
not seem to let me (I tried manually entering the link but it came up with it
was not able to do this).

Is there away around this or is it just the way it is. Although useful to
have on a separate sheet it is not essential.

Any help or suggestions (even if it is to say you can't!) greatly appreciated

Kind regards

Rexmann