![]() ![]() In the example below, I have named B2:D2 as Plasterboard, B3:C3 are named Bricks, B4 is named Panels Using named ranges, name cells to form the drop down list of quantities, as the item name.The second sheet is called ordering sheet and this is the sheet where the item to be ordered will be entered and next to the item will be the appropriate drop down list: ![]() I have two sheets, one called lists which contains a list of the items that will be ordered and the quantities that those items can be ordered in: There are a few steps to the process, which will need to be carried out in order. Always up for a challenge, I decided to use my creativity and I found a solution through the combined use of data validation and the indirect function. The reason for the question was so that estimators entering building supplies into a data list could enter the name of the material and then select from a list of quantities that that specific material can be ordered in. Creating a variable drop down down list using IndirectÄuring some advanced Excel training, I was asked how to create a variable drop down list in excel using a data validation list that changes depending on the value in a related cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |