Data Validation

R

rexmann

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
 
J

Jan Karel Pieterse

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.
Click to expand...

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
 
R

rexmann

Hi Challa

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

Kind regards

Rexmann
 
Top