Repeated validation lists in several worksheets
 

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,
--
Joe

VBA Automation/VB/C++/Web and DB development

Repeated validation lists in several worksheets
 

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

"Joe" wrote in message
...
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,
--
Joe

VBA Automation/VB/C++/Web and DB development

Repeated validation lists in several worksheets
 

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


"Joe" wrote in message
...
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" wrote:

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

"Joe" wrote in message
...
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,
--
Joe

VBA Automation/VB/C++/Web and DB development

Repeated validation lists in several worksheets
 

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

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
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



"Tom Ogilvy" wrote:

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


"Joe" wrote in message
...
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" wrote:

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

"Joe" wrote in message
...
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,
--
Joe

VBA Automation/VB/C++/Web and DB development