Repeated validation lists in several worksheets

[Joe]

I am using XL 2002 and have several validation lists that have values like
"Yes/No" and "Include in Quote/Do Not Include in Quote."

Is there any way for me to centralize these so that I don't have to maintain
the individual lists in several worksheets, but could rather maintain a sinle
"Yes/No" list and somehow reference it in the otehr worksheets??

TIA,

 

[Tom Ogilvy]

You would need to create a defined name in each workbook that will use the
centralized list and assign that defined name as the source for your drop
down validation list.

 

[Tom Ogilvy]

Assume you have a workbook named data.xls and on sheet1 you put in

A1: Yes
A2: No

This is your master list workbook.

Now,

In your workbook with the 10 sheets (where you want to put a validation)
you would do
Insert => Name => Define
Name: List1
RefersTo: =[Data.xls]Sheet1!$A$1:$A$2

Click the Add button
then go to any sheet in the 10 sheet workbook and do

Data=>Validation
select the list option and in the textbox for the list you would put

=List1


The only problem is that the master list workbook (data.xls in this case)
needs to be open for the validation list to work.

--
Regards,
Tom Ogilvy

Hi Tom,

Thanks for getting back to me.

I have one workbook and 10 worksheets. I don't follow what you've written
below. Could you be a bit more explicit? Maybe an example?

Thanks,

Joe

 

[Tom Ogilvy]

Sure, but that isn't what you originally asked <g>

--
Regards,
Tom Ogilvy

Otherwise I could just add an additional worksheet (say ValidationValues) to
host the validation list values and do the following:

Insert => Name => Define
Name: List1
RefersTo: =ValidationValues!$A$1:$A$2

and in the cell for which I need the validation list:

Data=>Validation
select the list option and in the textbox for the list you would put

=List1.

The result should be the same. Right?

Thanks,

Joe

Assume you have a workbook named data.xls and on sheet1 you put in

A1: Yes
A2: No

This is your master list workbook.

Now,

In your workbook with the 10 sheets (where you want to put a validation)
you would do
Insert => Name => Define
Name: List1
RefersTo: =[Data.xls]Sheet1!$A$1:$A$2

Click the Add button
then go to any sheet in the 10 sheet workbook and do

Data=>Validation
select the list option and in the textbox for the list you would put

=List1


The only problem is that the master list workbook (data.xls in this case)
needs to be open for the validation list to work.

--
Regards,
Tom Ogilvy

Hi Tom,

Thanks for getting back to me.

I have one workbook and 10 worksheets. I don't follow what you've written
below. Could you be a bit more explicit? Maybe an example?

Thanks,

Joe

:

You would need to create a defined name in each workbook that will

use
the

centralized list and assign that defined name as the source for your drop
down validation list.

--
Regards,
Tom Ogilvy

I am using XL 2002 and have several validation lists that have

values
like

"Yes/No" and "Include in Quote/Do Not Include in Quote."

Is there any way for me to centralize these so that I don't have to
maintain
the individual lists in several worksheets, but could rather

maintain
a

sinle
"Yes/No" list and somehow reference it in the otehr worksheets??

TIA,