In my workbook I have an excel sheet(called state_sum) with a some vlookups, arrays, and other basic formulas. The values on this sheet change based the state selected in cell A2.
I need to find a way of summing all of the values for a group for a region. For example the midwest - I would want to see one sheet with the values from ohio, michigan etc all summed.
The only way I could think of doing was creating a multi-selection listbox.
The way I would see this working is the user selects a state or a group of states in the listbox.
The state_sum sheet is copied, the value in a2 of the newly copied state sheet is set equal to the state selected, then the copied sheet is renamed to state selected.
A summary sheet would then need to sum the sheets created.
While I am very comfortable with excel and VBA I basically need know how to do the following to be able to implement this solution.
1) How do I pass the multi-selected state values?
2) How do I run a macro or an action using the selected values from listbox
3) How do I get the summary sheet to dynmically determine how many sheets to summarize?
I need to find a way of summing all of the values for a group for a region. For example the midwest - I would want to see one sheet with the values from ohio, michigan etc all summed.
The only way I could think of doing was creating a multi-selection listbox.
The way I would see this working is the user selects a state or a group of states in the listbox.
The state_sum sheet is copied, the value in a2 of the newly copied state sheet is set equal to the state selected, then the copied sheet is renamed to state selected.
A summary sheet would then need to sum the sheets created.
While I am very comfortable with excel and VBA I basically need know how to do the following to be able to implement this solution.
1) How do I pass the multi-selected state values?
2) How do I run a macro or an action using the selected values from listbox
3) How do I get the summary sheet to dynmically determine how many sheets to summarize?
