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?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
I've posted this on Expert Exchange (hope that's not a cross post since many people wont be able to see the solution).
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top