Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

A drop down list creating a drop down list

Avatar of GrahamSA
GrahamSAFlag for South Africa asked on
Microsoft Excel
2 Comments1 Solution348 ViewsLast Modified:
Hi Experts

What a great day!

OK here is my need, I have looked around but couldn't quite find what I am looking for.

I have a pretty large spreadsheet that needs to be populated with as little room for interpretation as possible.

So. I have 2 fields in question, Delay codes and Remarks.
The delay codes are found in a list in the second sheet somewhere and cause a drop down for the data capture person to select. Now each delay code has its own list of possible remarks that will apply.

Is there any way to have only the relevant remarks be available in the remarks drop down?

I have put together a file that will help you see what I need. The lists are all incomplete ad need to be easily edited and added too.

Thanks so much
example.xlsx
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppintoFlag of Portugal image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers