List

[Newbie]

Is there any way to have Data Validation List refer to a range of cells in a different sheet. I have product list that will be updated at least once a month in the first sheet and five other sheets that use product names from the product list, so i'd like to have drop-down list in the cell where product needs to be displayed.
Thank you in advance

 

[RagDyer]

Try Debra Dalgleish's web site, and scroll down to "D" to find everything
you need pertaining to Data Validation.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there any way to have Data Validation List refer to a range of cells in a
different sheet. I have product list that will be updated at least once a
month in the first sheet and five other sheets that use product names from
the product list, so i'd like to have drop-down list in the cell where
product needs to be displayed.
Thank you in advance

 

[Debra Dalgleish]

If you name the range that contains the product list, you can refer to
it in data validation on other sheets.

There are instructions on my web site:

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

 

[RagDyer]

Forgot to include the link, didn't I?

The old age excuse is starting to wear out!
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

If you name the range that contains the product list, you can refer to
it in data validation on other sheets.

There are instructions on my web site:

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

Is there any way to have Data Validation List refer to a range of cells in

a different sheet. I have product list that will be updated at least once a
month in the first sheet and five other sheets that use product names from
the product list, so i'd like to have drop-down list in the cell where
product needs to be displayed.

 

[Debra Dalgleish]

You spelled my name correctly though, and that's not as easy as it looks.

 

[RagDyer]

I cheat ... Ron's Google Add-In has it already spelled out for me in the
"Favorite Excel Sites"!<g>
--


Regards,

RD

 

[Newbie]

Thank you very much, I found the answer on Debra's web site.

 

[Newbie]

Thank you. Great site.

 

[Max]

You spelled my name correctly though,
and that's not as easy as it looks. ..

Agreed ... especially wrt "Dalgleish" ...
yet amazingly .. I've never goofed
on this point .. yet < bg >

 

[Vasant Nanavati]

You spelled my name correctly though, and that's not as easy as it looks.

Come on, it's not *that* hard ... and we can always refer to PD James's
books if we forget <vbg>.

Regards,

Vasant.

 

[Debra Dalgleish]

Ah, but the Inspector spells his name incorrectly!

 

[Debra Dalgleish]

And I appreciate it! But now I'll be watching. <g>

 

[Vasant Nanavati]

I know that ... just checking to see if you were awake enough to defend your
"good name" <g>.