Hi there,
I have an Excel workbook to manage the stocks of my little homebrewery. This workbook has four sheets: (1) A table where I note all movements, (2) A list with the stocks for malt, (3) A list with the stocks for hops, (4) A list with the stocks for yeast.
The sheets (2)-(4) contain the names of the different malts, hops, yeasts. In the first sheet (1) I want to have one column to select whether malt, hops or yeast has been added or taken out of the storage. Based on this selection, the next column should be a dropdown list that shows either the names of all malts (from sheet 2), all hops (sheet 3), or all yeast (sheet 4). However, I am struggling with this task. For the first entry in the table in sheet (1) I could arrange such a dynamic dropdown list. However, for the second row and so on, the selection of the dynamic dropdown is incorrect (it shows the name of the malts if I select hops,...).
Can anyone help me with this issue? Please find the workbook attached.
Thanks a lot!
Bookmarks