G
Guest
In cell A1, I have a drop down list (created by Validation feature), this
cell has department listed such as:
Electrical Dept
Plumbing Dept
Etc.
Now, I am looking at having another drop down list in cell A2 which gives me
the data based on first selection, for instance; if I choose Plumbing on A1,
list me only issues for plumbing in A2 such as:
Fitting
Pipe
Threads
Etc.
If the other department, list the others for this corresponding department.
I know this is possible in access but am not sure for excel. Maybe with VBA
code it code work in excel, too.
Thank you for any help/tip provided.
Adnan
cell has department listed such as:
Electrical Dept
Plumbing Dept
Etc.
Now, I am looking at having another drop down list in cell A2 which gives me
the data based on first selection, for instance; if I choose Plumbing on A1,
list me only issues for plumbing in A2 such as:
Fitting
Pipe
Threads
Etc.
If the other department, list the others for this corresponding department.
I know this is possible in access but am not sure for excel. Maybe with VBA
code it code work in excel, too.
Thank you for any help/tip provided.
Adnan