Hello-
I have a file with 8 worksheets, each representing a different location. I
need to create a Total worksheet that will allow the user to select how many
locations they would like to see in the Total.
Ex. User 1 wants to see the Total if all 8 locations are summed.
User 2 is conservative and only wants to see the Total of 5 locations. etc.

Ideally, I envision a drop down box at the top that can be changed by the
User that will in turn change the totals in the spreadsheet automatically.
Any ideas would be greatly appreciated!
--
JLS