Validation
Good morning,
In my Excel sheet, I have two fields: Project Type (B2) and Type of Work
(B4). Currently, I use Validation on both fields to have a drop-down for a
list of items. What I am hoping to do is, for example, if I select Project A
from the Project Type field, I only want Cell B4 to list the types of works
that apply to Project A, instead of listing entire list.
Can it be done?
Thanks.
|