Hi Everyone.
When I use Validation in one cell and I choose a department from that list what i would like it to do is then in the next validation automatically display a list of names for that oparticular department. Is there a way of doing this?
thanks
When I use Validation in one cell and I choose a department from that list what i would like it to do is then in the next validation automatically display a list of names for that oparticular department. Is there a way of doing this?
thanks