I have a sheet with a single list box which with many items listed in it, I have a seperate formula which refers to that list box and does its calculations based on what is selected and displays the results in the list box in the cell to the right of it
What I'm looking for is a way to have several list boxes going down the rows and for the formula to act on the current selected list box.
So if I change a value on row 1 the formula runs depending on what I selected. If i then change a value in another list box, say on row 2, the formula would calculate based on what I selected in that cell.
The formula basically builds a dynamic list of items depending on what was selected and then I use another list box to show those results, So by selecting something in the first listbox like "blue" it shows me all the cars in my table that has the blue colour assigned to them.
Similar to the code here
Use a drop down list to search and return multiple values | Get Digital Help - Microsoft Excel resource
If i just had the one list box then fine, But I want many rows of list boxes that do the same thing. If there was a way of using a dynamic name to have the current active cells data in it then I could incorporate this into my formula instead of having a unique cell reference....
How would I go about this?
(if you understand what I mean )
Example: here
Any help is appreciated.
What I'm looking for is a way to have several list boxes going down the rows and for the formula to act on the current selected list box.
So if I change a value on row 1 the formula runs depending on what I selected. If i then change a value in another list box, say on row 2, the formula would calculate based on what I selected in that cell.
The formula basically builds a dynamic list of items depending on what was selected and then I use another list box to show those results, So by selecting something in the first listbox like "blue" it shows me all the cars in my table that has the blue colour assigned to them.
Similar to the code here
Use a drop down list to search and return multiple values | Get Digital Help - Microsoft Excel resource
If i just had the one list box then fine, But I want many rows of list boxes that do the same thing. If there was a way of using a dynamic name to have the current active cells data in it then I could incorporate this into my formula instead of having a unique cell reference....
How would I go about this?
(if you understand what I mean )
Example: here
Any help is appreciated.
Last edited: