This one here is a little to define if you are not up to speed with my previous post. So let me try and not butcher this up too bad.
Issue: In the "executive dashboard" sheet I have a listbox named #3 that display the count and average for all the ID's that are in listbox1. I am wanting to modify the way listbox3 functions, by instead of listing ALL of the ID's and their counts and averages. I want to only show in listboxes3 the counts and averages for ONLY what ID#'s that have been selected to chart and the time frame that corresponds with that selection.
I have selected S2 and E1 in listbox1 to chart, and I choose to see 1 month. So this would mean that the chart is graphed with 2 ID's and listboxes3 only show the following:
ID# Count Averages
S2 800 200
E1 280 70
And this would be the case if I wanted to select more or less ID's.
Let me know if you have questions.. :) NOC-Reports-r24.xlsm