| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists on multiple worksheets
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!A5:Data!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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists to transfer data between worksheets | Excel Worksheet Functions | |||
| Multiple drop-down lists to get a value | Excel Discussion (Misc queries) | |||
| Direction combine several excel worksheets, drop down lists and da | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| multiple drop down lists | Excel Discussion (Misc queries) | |||
Threaded Mode
