Data validation list in a different tab

[alyssa75]

I want the data validation list to look a range on a different tab for the list of allowed values. Is this possible using data validation?

If not, anyone have an example of VBA code for this?

Thanks!

 

[HalfAce]

Sure. On the sheet where you want the list to reside, give your list's range a defined range name. (Insert > Name > Define. Name it something like "MyValidationRange").

Then on the other sheet where your validation dropdown will reside, use
Data > Validation > List and for the source, enter =MyValidationRange (or whatever you really named the range).

Hope it helps.

EDIT:
We can come up with a number of ways to do this with vba, but the validation method is the way I would go.

 

[alyssa75]

NICE! Thanks!

 

[HalfAce]

Most welcome. Glad it helped.