Is it possible to modify a drop down list based on the value of another cell?

[spurs]

I want to create a drop down list in a cell but the items in the drop down list can change depending on the value in a different cell

How can I do this?

 

[Peter_SSs]

Here is one place you can investigate that.

Easy Steps Excel Dependent Drop Down List Data Validation

Easy steps for Excel dependent drop down list. Conditional data validation based on other cell, Region/City. Videos, written steps, get free Excel file

contextures.com

 

[spurs]

Thank you for your help

I found a better link that is easier to use

Creating a Dependent Drop Down List in Excel [Step-by-Step Tutorial]

In this tutorial, you will find the step-by-step process of creating a Dependent Drop Down List in Excel (aka conditional drop down list).

trumpexcel.com

 

[Peter_SSs]

You're welcome.