Need some help. In one sheet I have historical sales data. It also has sum data at the bottom, summed by month. This sum data is what I am currently feeding into a chart on another sheet
manually. What I would like to happen is that the I have two drop down lists populate cells for each month based on what the drop list has selected.
In cell "H3" I need it to display unique values
Dynamic data:
Type1
Type1
Type2
Type2
Type2
Type3
Type3
will display in the validation list as
All Types (cell is blank?)
Type1
Type2
Type3
In cell "I3" I have the data validation pulling a named range and the list works just fine. This would also be dependent of "H3"
In cell "C20" is the value needed for the chart
What is the best method to string these together and populate "C20?"
Best reference I could find:
https://www.mrexcel.com/forum/excel-questions/488149-unique-list-use-validation-list.html
manually. What I would like to happen is that the I have two drop down lists populate cells for each month based on what the drop list has selected.
In cell "H3" I need it to display unique values
Dynamic data:
Type1
Type1
Type2
Type2
Type2
Type3
Type3
will display in the validation list as
All Types (cell is blank?)
Type1
Type2
Type3
In cell "I3" I have the data validation pulling a named range and the list works just fine. This would also be dependent of "H3"
In cell "C20" is the value needed for the chart
What is the best method to string these together and populate "C20?"
Best reference I could find:
https://www.mrexcel.com/forum/excel-questions/488149-unique-list-use-validation-list.html
Last edited: