Drop down lists on multiple worksheets

[Phil]

I have a single worksheet with multiple drop down lists on it, and the
choices that are made are then compiled together. The one sheet works just
fine it uses a reference to a range of cells on another sheet ie
=SUM(Data!A5ata!A68). The problem is that I need to create multiple
worksheets all with the same data but the sum function needs to work
independently for each worksheet. Basically I need to know how to create
other Data sheets to store the users choices on the drop down list so that
each user worksheet has its own "Data" sheet.

 

[AnthonyHo2008]

Have you ever use the "List" criteria inside the "Data - Validation"? You
can select a range in your worksheet for the choices in the drop down.
After, duplicate the worksheet so that you do not need to redo it again.

Hope it can help.

 

[Shane Devenshire]

Hi,

1. I don't follow what it is you want, why not show us an example.
2. Your formula below is not valid and will return a REF error:
=SUM(Data!A5ata!A68)
It should be SUM(Data!A5:A68)

If this helps, please click the Yes button

Cheers,
Shane Devenshire