Conditional Validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Narcissist - 04 Feb 2008 10:30 GMT

Hi Everyone,

I'm stuck up with a problem here and I hope I'll get some help here. I want
a conditional validation done on one of my cells. This is how it goes. I'm
working on a report that spans multiple teams across multiple locations. The
person running the report will have to select the location from a list
validation. Now, based on the location selected, I want another list
validation for the team field. This list should carry only the teams active
in the selected location. Is there any way this can be done without involving
programming?

Thanks,

Sam

Reply to this Message

George - 04 Feb 2008 10:37 GMT

Sounds like you could use the Dependent List validation approach which you
can find about here...

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

I would imagine you'd be able to then generate named ranges for locations
and teams. Then using the INDIRECT function you should be able to change the
validation done on the team cell based on the location that's chosen.

George.

> Hi Everyone,
>
[quoted text clipped - 10 lines]
>
> Sam

Reply to this Message

The Narcissist - 04 Feb 2008 10:56 GMT

Thanks George. That worked for me. :)

> Sounds like you could use the Dependent List validation approach which you
> can find about here...
[quoted text clipped - 21 lines]
> >
> > Sam

Reply to this Message

George - 04 Feb 2008 11:13 GMT

Great. I've had so much help from this discussion group it's about time I
contributed back into the knowledge :-)

> Thanks George. That worked for me. :)
>
[quoted text clipped - 23 lines]
> > >
> > > Sam

Reply to this Message