Once the ID and the Category has been selected, it should pull the corresponding First, Second and Third value from the selected category.
If there would be a value below Category 3 it should create a dropdown list with 3. In the example below it should create a dropdown list with the values "Example 1 and Example 2". Once an ID has been selected in Tab 1, it should automatically generate a dropdown list including all Category Values (if not empty). The dropdown list in the first cell is simply the range of all the values in the 'B' column of the data tab. Once an ID and one of the categories is selected in the first tab, it should pull the 3 unique values of that specific Category and display it in the first tab. It should only pull the categories which are not empty.
When selecting an item ID in the first tab, it should generate a dropdown list with all of the Category names of the item with the same ID from the data tab. The data consists out of one ID and up to 4 categories with each category having 3 unique values. One tab showing the data based on the selected parameters (ID and Category) and one tab with all of the data.
Not sure how to phrase this correctly, but I can't get my head around the next thing
0 kommentar(er)
