Multi-List Value Copies Sheets Based on Values

banker

New Member
Joined
Feb 25, 2009
Messages
2
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?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

banker

New Member
Joined
Feb 25, 2009
Messages
2
I've posted this on Expert Exchange (hope that's not a cross post since many people wont be able to see the solution).
 

Watch MrExcel Video

Forum statistics

Threads
1,108,618
Messages
5,523,933
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top