I understand you want to be able to select what sheets are used in a
calculation *but* you haven't defined what that calculation is or what cells
need to be included.

--
Biff
Microsoft Excel MVP


"JLS" wrote in message
...
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